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)

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

Thanks!!
###### Who is Participating?

PresidentCommented:

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))
``````

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

Commented:
ThinkSpaceSolutions,

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?
0

PresidentCommented:
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.
0

Author Commented:
Thanks!!
0

PresidentCommented:
Not a problem HDM.  For future references with Google Spreadsheet functions, you can visit the Google Support pages and search for the function list.
0
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.