count by name, the number of xs per name

[rsturner82]

in excel i have a spreadsheet. I ave advisors name and another column with x in.

i want to count by name, the number of xs per name for example:


B1 C1

Gill x
Steve
Richard x
Dan


the result for this should be:

gill 1
steve 0
richard 1
dan 0

i can use the functions but dont quite know how to do this. any help please?
Thanks

[jovialtom]

if you are only ever going to use x's in the column then the len function will suffice.
Tom

[rsturner82]

but i need to count how many xs each person has, the persons names appear once such as:

richard x
dan
richard x

which would results as

richard 2
dan 0,

but i cannot find a function to specify the two arguments, such as count the number or richards in the column, then count how many of the richards have x`s in the next column.

[rsturner82]

but i need to count how many xs each person has, the persons names appear more than once such as:

richard x
dan
richard x

which would results as

richard 2
dan 0,

but i cannot find a function to specify the two arguments, such as count the number or richards in the column, then count how many of the richards have x`s in the next column

[SamuelT]

Hi,

SUMPRODUCT will do this for you. Something along the lines of:

=SUMPRODUCT(--(B1:B100="Richard")*(C1:C100="x"))

HTH,

SamuelT

[rsturner82]

thanks alot SamuelT, worked exactly how i wanted it too!

[SamuelT]

Glad to help - thanks for the feedback