Forum Discussion
Solved
Adding values generated by IF Function
Hi all trying to set up a QA spreadsheet with Yes/No answers. I used the =IF(B9="Yes"; "1";"0") To generate values in Column C I want to add up those values in column C to get a total so I used =...
Putting numbers in quotation mark " " makes them text. Try this before summing: =IF(B9="Yes",1,0).
Another way to count the Yes(es) without needing column C is: =COUNTIF(B9:B41,"Yes").
We could make guesses as to which column is which, probably accurate guesses, but far better than an incomplete image would be for you to attach the actual spreadsheet to your query. It clearly isn't confidential, since you've posted an image. That way we could make more fully informed suggestions.
I was informed that I used double quotes for numerical values when I wasn't supposed to.
Didn't know we could link the actual sheet to the question but thanks, I'll do it next time😅