How to add up N/A answers in a spreadsheet [SOLVED]

[jazzkid]

I need to add the number of N/A answers in a spreadsheet.


I have uploaded the spreadsheet to https://www.dropbox.com/s/l7hfh5y6f4q27m5/Oral_Dental_audit.xlsx


At this stage the additions of the N/A answers is done manually. Need to make it idiot proof


If anyone can assist I would really appreciate it.


Thanks


Sue

 

[oldchippy]

Hi Sue,


Try this,


=COUNTIF(C12:Q12,"N/A")

 

[NARAYANK991]

Hi Sue ,


This is not related to your question , but please note that cell R21 is missing its formula , as a result of which the values in row 21 have not been included in your totals ; please check this.


Narayan

 

[jazzkid]

Thanks to both Oldchippy and Narayan


The formula worked thanks, and I rectified cell R21 - not an incredibly better result for the audit - but still every little helps when you're not doing too well.

 

[oldchippy]

Thanks for the feedback Sue, much appreciated