SumIfs

[TanishaS09]

Hi! I am trying to do a SumIfs statement. I have a data validation list in a column and and trying to sum if the criteria in that one column matches. All of the posts I have seen have the criteria to look for in separate columns. Is it possible to do a SumIfs if all of the criteria are in the same column? Here is my attempt:
=sumifs(I8:I24,G8:G24,"Company CC",I8:I24,G8:H24,"Company CK",I8:I24,G8:H24,"Company Cash") Thanks!

 

[tyija1995]

Hey how about this:

SUMPRODUCT((G8:G24="Company Cash")+(G8:G24="Company CC")+(G8:G24="Company CK"),(I8:I24))

 

[Fluff]

How about
=SUMPRODUCT((G8:G24={"Company CC","Company CK","Company Cash"})*(I8:I24))

 

[TanishaS09]

This worked, thanks for your help!

 

[TanishaS09]

Thank you for taking a look, appreciate it!

 

[Fluff]

Glad we could help & thanks for the feedback