If formula to add up a range of cells

[loonger]

Hi there,

New to this forum.
Excel 2010 user.

I am in need of an IF Formula for the attached report.
I basically need to sum all variances according to the identifiers column.
Example: Need a sum of all variances with "A" identifier, and another sum of variances of "B" identifier, etc.
I am working with hundred of cells so wanted to know if there is a quicker way of looking up a range of cell rather than using individual IF formulas for each cell.

Thanks in advance for your help!

[ben_hensel]

This is what the SUMIF formula is for:

output = SUMIF(test_range, boolean_test, summation_range)

For you:

output_A = SUMIF(E3:E100, "A", C3:C100)

like that.

[Olly]

Try a pivot table - see attached.

[loonger]

Thanks Ben and OllyXLS. Both worked. The SUMIF formula was definitely what I was after but the Pivot table will come in handy as well.
Thanks to the both of you.

[Tremper]

=countif(e3:e14,"=a")