Hi Jason
That's exactly what a Pivot Table in its simplest form does. See
http://www.cpearson.com/excel/pivots.htm on how to set it up.
--
HTH. Best wishes Harald
Followup to newsgroup only please.
"Jason" wrote in message
...
Greetings,
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).
Thanks in advance!
Regards,
Jason