SUMIFS with multiple possibilities for one criteria.

[EdStockton]

Hi All,

I'm wanting to use the sumifs function with one of the criteria having more than one possible correct matches.

I know the normal SUMIFS function would work as follows yielding a total from cells G10 through G100 based on whether a common row in the range contained in columns A, B, and C the requisite criteria specified in cells A5, B5, or C5.

=SUMIFS(G10:G100,A10:A100,A5,B10:B100,B5,C10:C100,C5)

How I would like to modify this is to allow the criteria for Column C to be one of several possibilities. For example, instead of restricting the criteria in Column C to the contents of Cell C5, I would like to have the option of having the contents of Column C be equal to the contents of either cell C3, C4, C5, or C6.

I'm sure there is a way to do that, I just don't know how.

Thank you, Ed

 

[Marcelo Branco]

Try

=SUMPRODUCT(SUMIFS(G10:G100,A10:A100,A5,B10:B100,B5,C10:C100,C3:C6))

M.

 

[EdStockton]

Marcelo Branco,

Thank you for your quick and accurate response. You made that seem so simple.

Thanks, EdStockton