Groupings
On Fri, 30 Jan 2004 19:56:11 GMT, Jason wrote:
SumIf will do this for you:
=SUMIF(A1:A5,"joe",B1:B5)
I have a chart that looks a little like this:
a b
1 bob 1
2 joe 1
3 harry 2
4 joe 2
5 bob 1
...etc.
Is it possible for me to have a cell that is a sum of every cell in the
column "b" where the name in column "a" is "joe"? In the above example,
the correct answer would be 3 (because b2 plus b4).
---------------------------------------------------------
Hank Scorpio
scorpionet who hates spam is at iprimus.com.au (You know what to do.)
* Please keep all replies in this Newsgroup. Thanks! *
|