Thread
:
sumif multiple criteria
View Single Post
#
5
Posted to microsoft.public.excel.worksheet.functions
Chris Cowles
external usenet poster
Posts: 5
sumif multiple criteria
"Ragdyer" wrote in message ...
Try these:
=SUM(SUMIF(A:A,{"A","B","E"},C:C))
=SUM(SUMIF(A:A,{"C","D"},C:C))
It does, and looks elegant. What's the effect of the braces, if the outer SUM() were not there?
Reply With Quote
Chris Cowles
View Public Profile
Find all posts by Chris Cowles