Forum Discussion
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 =SUM(C9:C41) but it's not generating the total. I also tried =SUM(IF(B2:B14="Yes"; 1;0)) which worked but only added up a few of the values in column C
What can I do to fix this?
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").
4 Replies
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").
Thank you! It worked out💪
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😅
