how to summarize total number of appearance in a column?

[Alberta H K]

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.

 

[Peo Sjoblom]

=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


--


Regards,


Peo Sjoblom

 

[Alberta H K]

Thank you Peo.

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

Thank you. Alberta

 

[Peo Sjoblom]

In your example you should put John in C1


--


Regards,


Peo Sjoblom