Forum Discussion
Count data depending on what's in another column
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 s...
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")