counting occurrences

[dpwicz]

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

 

[Sean Timmons]

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

 

[Max]

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