Oct 16 2022 05:21 PM - edited Oct 16 2022 05:21 PM
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.
Oct 16 2022 05:42 PM
Oct 16 2022 06:32 PM
Oct 16 2022 07:45 PM
@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")