View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Pete_UK Pete_UK is offline
external usenet poster
 
Posts: 8,856
Default SUMIF multiple criteria

Try it this way:

=SUMIF(A:A,10,B:B) + SUMIF(A:A,11,B:B)

Hope this helps.

Pete

On Oct 29, 4:14*pm, Zia wrote:
Hi,
I have two columns A and B. A column has Account # and B column has amounts *
A * * * * * * * *B
10 * * *100
11 * * *200
10 * * *300
13 * * *400
14 * * *500
11 * * *600
Now I want to sum column B if value in column A is either equal to 10 OR 11?
so the formula in the above example should return *1200.
Thanks in advance