SUMIF used together with FILTER function in Google Spreadsheet

filter sum google-docs sumifs
walter tabax picture walter tabax · May 23, 2013 · Viewed 14.1k times · Source

It seems that Google Docs doesn't offer the SUMIFS function. Instead, it was suggested to use a workaround combining SUM with FILTER

I'm trying to sum values filtering months in a specific year.

I've created a formula like this: =sum(FILTER(H:H,A:A>="01/02/2013",A:A<="28/02/2013")) but something must be wrong, I have an error message.

H = values A = dates

I made another test, creating two cells with the dates. E.g. cell L3 with the date 01/02/2013, and cell M3 with the date 28/02/2013

Formula used is: =sum(FILTER(H:H,A:A,">="&L3,"<="&M3)) - Didn't work as well.

Can anybody find what is wrong in it? (the DD/MM/YYYY is setted as correct = portuguese language - so it's not MM/DD/YYYY).

thanks.

I've shared by link the Spreadsheet, only for view, if necessary.

Answer

Veit Richter picture Veit Richter · Apr 5, 2018

I guess, I found a solution. Try using: =subtotal(109;B2:B999)

Related questions

Remove rows with all or some NAs (missing values) in data.frame

I'd like to remove the lines in this data frame that: a) contain NAs across all columns. Below is my example data frame. gene hsap mmul mmus rnor cfam 1 ENSG00000208234 0 NA NA NA NA 2 ENSG00000199674 0 2 2 2 2 3 ENSG00000221622 0 NA NA NA NA 4 …

Read More
List comprehension vs. lambda + filter

I happened to find myself having a basic filtering need: I have a list and I have to filter it by an attribute of the items. My code looked like this: my_list = [x for x in my_list if …

Read More
What is the best way to filter a Java Collection?

I want to filter a java.util.Collection based on a predicate.

Read More