how to summarize total number of appearance in a column?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Alberta H K - 19 Dec 2007 17:29 GMT

Can you tell me how to summarize total number of appearance in a column?
For example, I have a column with three names appear at different rows
another column with value to the names:

John 45
Mary 15
John 33
Rick 10
Rick 11
Mary 31
Mary 22
John 0

How can I summarize: Number of times John appears (3 times),
and the total number in John's row (45+33+0=78).

Thank you.

Reply to this Message

Peo Sjoblom - 19 Dec 2007 17:36 GMT

=COUNTIF(A1:A10,"John")

=SUMIF(A1:A10,"John",B1:B10)

if you replace "John" with a cell like C1 you can use

=COUNTIF(A1:A10,C1)

=SUMIF(A1:A10,C1,B1:B10)

and just put the criteria in C1

Signature

Regards,

Peo Sjoblom

> Can you tell me how to summarize total number of appearance in a column?
> For example, I have a column with three names appear at different rows
[quoted text clipped - 13 lines]
>
> Thank you.

Reply to this Message

Alberta H K - 19 Dec 2007 19:09 GMT

Thank you Peo.

Can you give me an example of criteria in C1 should be?
Should C1 be a number?

Thank you. Alberta

> =COUNTIF(A1:A10,"John")
>
[quoted text clipped - 25 lines]
>>
>> Thank you.

Reply to this Message

Peo Sjoblom - 19 Dec 2007 20:42 GMT

In your example you should put John in C1

Signature

Regards,

Peo Sjoblom

> Thank you Peo.
>
[quoted text clipped - 32 lines]
>>>
>>> Thank you.

Reply to this Message