Say ColA is the criteria I want to check against and ColB is the column I want to sum:
If you have only 1 Criteria then it's easy: =SUMIFS(Table1[ColB],Table1[ColA],"DOG")
But how do you do it if you want to sum ColB if ColA is either "DOG" or "CAT"?
Seems easy conceptually....(and I guess you could use SUMPRODUCT but want the efficiency of the *IFS functions) but can't figure it out googling....which tells me I'm really missing something.
Is it possible?
Many thanks,
Al
Bookmarks