# Help with sum formula...

##### Board Regular
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.

### Excel Facts

Which came first: VisiCalc or Lotus 1-2-3?
Dan Bricklin and Bob Frankston debuted VisiCalc in 1979 as a Visible Calculator. Lotus 1-2-3 debuted in the early 1980's, from Mitch Kapor.
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.

Thanks rs2k.

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

Once again, thanks!

Replies
6
Views
62
Replies
11
Views
135
Replies
2
Views
302
Replies
1
Views
127
Replies
5
Views
128

1,207,012
Messages
6,076,147
Members
446,187
Latest member
LMill

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

### Which adblocker are you using?

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

### Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back