Forum Discussion

cheeseontoast101's avatar
cheeseontoast101
Copper Contributor
Oct 17, 2022

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

excel
Formulas and Functions

3 Replies

  • Nothing_Left_to_Lose's avatar
    Nothing_Left_to_Lose
    Brass Contributor
    Oct 17, 2022
    =IF(C3="Yes",1, 0) '--- Nothing Left toLose https://1drv.ms/u/s!Au8Lyt79SOuhZw2MCH7_7MuLj04?e=sAwbHU (free excel programs)
    • cheeseontoast101's avatar
      cheeseontoast101
      Copper Contributor
      Oct 17, 2022
      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.

Resources