Count data depending on what's in another column

Contributor

Hi

I want to tally my data depending on what it says in the other column.

 

Attached is dummy example but basically if it say's yes I want it to add +1 to the total in the relevant column. If it says no, however, I don't want it to add to the total.

 

Can this be done?

 

I have access to 365 as well - I've just quickly done this example on my other computer that doesn't have it.

3 Replies
=IF(C3="Yes",1, 0) '--- Nothing Left toLose https://1drv.ms/u/s!Au8Lyt79SOuhZw2MCH7_7MuLj04?e=sAwbHU (free excel programs)
Hi thanks for your response but that's not exactly what I am asking.

I basically want to have something that says IF C2:C30 = "Reason 1" and D2:D30 = winner add 1, if not add 0 - obviously that's not the right syntax though.

@cheeseontoast101 For Microsoft-365 user.

=BYCOL(F2:I2,LAMBDA(x,COUNTIFS(B3:B7,x,C3:C7,"YES")))

For other versions user.

=COUNTIFS($B$3:$B$7,F$2,$C$3:$C$7,"YES")

Harun24HR_0-1665974682785.png