Count or Sum ?
 

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.

Count or Sum ?
 

Use the countif() function.

--
Dan Oakes

Count or Sum ?
 

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

On Oct 11, 12:03 pm, "Dan R." wrote:
Use the countif() function.

--
Dan Oakes

Count or Sum ?
 

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.

" wrote:

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

On Oct 11, 12:03 pm, "Dan R." wrote:
Use the countif() function.

--
Dan Oakes