Count or Sum ?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have two columns of data:

Name Value
A 1
A 1
B 1
C 1
C 1
C 1

I would like to sum or count each value in the Name column so that the
results would be:

A 2
B 1
C 3

There could be instances were the rows get sorted so that Names may not also
appear together or in the same order and there could be additional rows added.

Any suggestions would be appreciated.
 
Karen

countif will work for summing or counting as long as all you numbers
are 1's. If that is not the case in you real data then you can use
sumif(), or sumproduct() or a pivot table.

Good luck.

Ken
 
Thanks - Sumif is what I needed. I realized that my example was not as
clear and was about to repost, I am actually trying to sum the values in the
second column, which will not always be 1.

Thanks for your help.
 
Back
Top