Thread: SumIf with an Or
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
shail shail is offline
external usenet poster
  
Posts: 195
Default SumIf with an Or
Hi Karen,

This might help you -

=SUM(IF(A10=61505,B9:B11,IF(A10=61515,B9:B11,IF(A1 0=61517,B9:B11))))

This is an array function so you need to press Alt+Ctrl then Enter. If
you did it correctly braces {} will appear.


Thanks,

Shail

Reply With QuoteReply With Quote