A computer application that simulates a paper accounting worksheet.
2
votes
1answer
1k views
Is there a way to filter columns in Google Docs?
Is there a way to filter columns in Google Docs?
Column (A) contains new data
Column (B) contains filter data, i.e. cells with text that should not be included in column C
Column (C) is the outcome, ...
4
votes
2answers
5k views
How to sum values in a range of dates in Google Docs Spreadsheets?
I have a Google Docs spreadsheet in the format below — here's an example.
Column A → Dates
Column B → Numbers
I'd like to sum values in column B in a range of dates in column A.
Example:
...
3
votes
1answer
3k views
Multiple Conditions on a CountIF?
I have a spreadsheet that is essentially a todo list for different groups. I have a column for Group and Status. Both have data validation drop downs so I can reliably match the text content.
I have ...
0
votes
0answers
26 views
Google Docs spreadsheets: how to specify entire sheet as range?
The best workaround I have found so far is:
worksheet_name!$A$1:$YY
but ideally I would like to be able to simply write, e.g.:
worksheet_name!
So, does anyone know: is there a syntax for ...
