Help with sum formula...

[radar2000]

Hi everyone.

I need some help with a formula that looks at employee names and sums the total ballots earned for the employee name.

For example column A contains the following data:

A1 = ABC
A2 = ABC
A3 = ABC
A4 = DEF
A5 = DEF

Column B contains the following data:

B1 = 5
B2 = 5
B3 = 2
B4 = 10
B5 = 5

I need the sum of ballots earned for employee ABC to go into Cell C1.
I need the sum of ballots earned for employee DEF to go into Cell C2.

If someone could please help me out, that would be appreciated.

Thank you.

 

[rs2k]

In C1 type ABC, in C2 type DEF.
in D1 enter =SUMIF(A1:A5,C1,B1:B5)
in D2 enter =SUMIF(A1:A5,C2,B1:B5)

If your formula total has to go into C1 & C2 then use some spare cells to reference.

in C1 enter =SUMIF(A1:A5,Z1,B1:B5)
in C2 enter =SUMIF(A1:A5,Z2,B1:B5)
were Z1 & Z2 house ABC & DEF.

Colin.

 

[radar2000]

Thanks rs2k.

This is a great start...I will try and expand my report based on this formula.

Once again, thanks!