Conditional sumation

[Craig Silver]

I'm having a problem with SUMIF that should be very simple.

I have two columns A and B. I need to create a cell with the sum of all A
in a range where that row's B is a given value.

For example,

A B
1 4 2
2 5 8
3 2 (null)
4 3 2


If I'm looking for all rows with the B value of 2, I'd like to get the
result 7.

any suggestions?

Thanks.

 

[Peo Sjoblom]

=SUMIF(B:B,2,A:A)