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...
=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.
