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
|