Thread: SumIf - More then 1 criteria - Please assist
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Biff Biff is offline
external usenet poster
  
Posts: 1,688
Default SumIf - More then 1 criteria - Please assist
=SUM(SUMIF(A1:A10,{"x","y"},B1:B10))

Biff

"Nir" wrote in message
...
Hi,
How can i use sumif formula with more then ONE criteria?


Reply With QuoteReply With Quote