Excel 2003 - Selective sum

[C Brandt]

I have a fairly large block of data where I would like to pull the sum of
one column based on the data in another column.
e.g.
Name Date $
John 6/7/07 +100
Jill 6/7/07 -20
Sam 6/8/07 +35
John 6/9/07 +63
Joy 6/10/07 -10
Bill 6/10/07 +26
John 6/10/07 -76

Is there a formula where I can sum the $ column where there is a "John" in
the Name Column.

Thanks for any help,
Craig

 

[Kevin B]

You could use a SUMIF function similar to the one that follows:

=SUMIF(A2:A8,"=John",C2:C8)

Where A2:A8 is the criteria range, "=John" is the criteria and C2:C8 is the
range to sum.

The example assumes that the first cell label ('Name') is in A1.

 

[Farhad]

Hi,

Try this:

=SUMIF(A2:A100,"John",C2:C100)

Thanks,