Hello,

I am trying to count the occurrence of names in one column that have a value
in the next column and display the totals for each name.

i.e.

name A 10
name B 5
name A 5
name C 20
name A 10

Total name A 25
Total name B 5
Total name C 20

=sumif(column A cells,nameA,column B cells)

"dpwicz" wrote:

Hello,

I am trying to count the occurrence of names in one column that have a value
in the next column and display the totals for each name.

i.e.

name A 10
name B 5
name A 5
name C 20
name A 10

Total name A 25
Total name B 5
Total name C 20

Suggest a pivot table. Just a couple of seconds, and you're home. Assuming
your col headers are Name, Amt, in the "Layout" step of the pivot wizard,
just place Name in ROW area, Amt in DATA area, click OK Finish. Hop over to
the pivot sheet for the results: the unique names will be listed in the 1st
col with the corresponding sums of the amts adjacent to it.
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:18,300 Files:361 Subscribers:58
xdemechanik
---
"dpwicz" wrote:
I am trying to count the occurrence of names in one column that have a value
in the next column and display the totals for each name.

i.e.

name A 10
name B 5
name A 5
name C 20
name A 10

Total name A 25
Total name B 5
Total name C 20