Count or Sum ?

K

karen

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.
 
K

krcowen

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
 
K

karen

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.
 
Top