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

excel

Formulas and Functions

ScottAng
Mar 06, 2025
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").

ScottAng

Brass Contributor

Mar 06, 2025

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

Tanaaaa
Copper Contributor
Mar 06, 2025
Thank you! It worked out💪

Forum Discussion

Adding values generated by IF Function

Resources