Conditional sumation

  • Thread starter Thread starter Craig Silver
  • Start date Start date
C

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.
 
Back
Top