View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Chris Cowles Chris Cowles is offline
external usenet poster
 
Posts: 5
Default 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?