Google Drive Spread sheet SUMIFS

In Excel I use this statement:
=SUMIFS('Family List'!A:A,'Family List'!C:C,"=PE",'Family List'!G:G,">="&G4,'Family List'!G:G,"<="&I4)

This does not seem to work in Google Drive Sprread sheet.

Is there an equation that would do the same thing??

Curtis LongAsked:
Who is Participating?
Steven HarrisConnect With a Mentor PresidentCommented:
Unfortunately, Google Spreadsheets don't support the SUMIFS function.

Try using a SUM(Filter()):

SUM (Filter ([Sum Range], [All the criteria Ranges separated with a ; or a , ]))

=SUM(FILTER('Family List'!A:A,'Family List'!C:C="PE";'Family List'!G:G>=&G4;'Family List'!G:G<=&I4))

Open in new window

You may need to further define the criteria as I am free-handing the formula.
Harry LeeCommented:

Just wondering where did you get the idea of using Filter in the formula? Filter is not a valid formula function of Excel. Or is any add-on needed to use that formula function?
Steven HarrisPresidentCommented:
The OP is looking for a similar formula to SUMIFS, but the formula will be used in Google Spreadsheets, not in Excel.

In Google Spreadhseets, there is a function called FILTER which returns a filtered version of the given source array.

Once those Filters are set, we can now SUM them.  This creates the SUMIFS bypass.
Curtis LongAuthor Commented:
Steven HarrisPresidentCommented:
Not a problem HDM.  For future references with Google Spreadsheet functions, you can visit the Google Support pages and search for the function list.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.