Thread: Groupings
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Trevor Shuttleworth Trevor Shuttleworth is offline
external usenet poster
 
Posts: 1,089
Default Groupings

Jason

you need to use SUMIF

For example:

=SUMIF(A:A,"bob",B:B)

Regards

Trevor


"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