Conditional sumation

Giganews Newsgroups
Subject: Conditional sumation
Posted by:  Craig Silver (craig.silv…
Date: Fri, 31 Oct 2003

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?