1
vote
1answer
20 views

How can I collect the sum of different columns while filtering?

I am creating a travel budget spreadsheet and need to be able to sum different filters (By Month, By Salesperson, By State, etc)...is there a way for me to display the sum of a column based on what is ...
0
votes
1answer
58 views

Use sort function but filter results

I'm looking to use the =SORT function on some data, but I only want the first result with that name. Column A contains a Name, column B contains a level, and column C contains a date. I'm currently ...
2
votes
1answer
2k views

Google Spreadsheet - How to filter, SUM and display multiple values with multiple conditions added daily?

I have a spreadsheet that collects dozens of payments made daily through different means. For example, utilities bills, credit cards bills, personnel fees, expenses, etc. They are made in cash, by ...
1
vote
2answers
1k views

IF statement in Google spreadsheet

I am trying to sum up the total of all values in a coloumn that are POSITIVE. Also, I have some subtotals in the coloumn that should be left out from this sum. =SUMIF(E6:E65 ; ">0" ) - ...
1
vote
1answer
171 views

Google Spreadsheets Filtering data in another page and changing data in the original

I have a lot of data that I need to filter. I did it in another page and that's good... but now I need to put some values in that page... and transfer that data to the original. This is the formula ...
5
votes
2answers
5k views

Google Spreadsheets Filter() - referencing source array in criteria

The filter() function looks through a source array, and filters it according to condition =FILTER(A:A,ISNUMBER(A:A)) My source array is a rather long formula, so i end up repeating the same formula ...