counting problem

[HSOLDO]

hello,

i have column A that has names and column B that has yes or no.
I need to count how many times same name in column a received Yes and how many times it received no.

for example:
A1=alex B1=yes
A2=alex B2=no
A3=marcus B3=no
A4=alex B4=yes

G4= how many times alex received yes?
G5= how many times alex received no?

thanks

 

[Weaver]

G4: = sumproduct(--(A1:A4="Alex"),--(B1:B4="Yes"))
G5: = sumproduct(--(A1:A4="Alex"),--(B1:B4="No"))

You may need to extend the ranges to fit your full dataset

You can use pivot tables for this type of task, so long as the data has column headers. Especially useful if there are lots of names and/or combinations of result.

 

[HSOLDO]

thank you

 

[Aladin Akyurek]

hello,

i have column A that has names and column B that has yes or no.
I need to count how many times same name in column a received Yes and how many times it received no.

for example:
A1=alex B1=yes
A2=alex B2=no
A3=marcus B3=no
A4=alex B4=yes

G4= how many times alex received yes?
G5= how many times alex received no?

thanks

G4:

=SUMPRODUCT(--($A$1:$A$4="Alex"),--($B$1:$B$4="Yes"))

In G5 the same formula with No substituted for Yes...