=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