vendredi 18 septembre 2015

data from 2 different columns in one if statement google

I'm hoping someone can help me figure out how to make this work or give me an easier way to do this.

I have spreadsheet linked to a form that's been getting responses for several years. I recently took over the sheet and changed/added some questions. In one column, this formula was in every cell in the column (and a similar formula in every other cell of a couple of sheets) to count for each response

=IF(AND('Form Respones'!C6="Bought",'Form Responses'!K6="No"),1,0)

With my changes in the questions, I now need to also count responses from another column because I moved the no response to a different response and changed it to none. I was given this as a suggested formula to count 1 from both columns, but all it returns is 0s even for cells the previous formula had a 1.

=IF(AND('Form Responses'!B6="Girl",OR('Form Responses'!J6="None",'Form Responses'!J6="No")),1,0)

I'd really appreciate any help anyone can give me to get this working right. Thanks!

Aucun commentaire:

Enregistrer un commentaire