I have a spreadsheet of data which lists the inspection results of schools, in which I have a column that states the result or is empty if that particular school has not yet been inspected. I want there to be a cell which returns the number of schools that have been inspected. I assume that the best way to do this is to check whether or not the 'inspection result' cell has anything in it, and if it does add 1 to this 'total inspected' cell. I've tried writing an IF statement but it isn't working:=IF(   OR(     'Indiviual FS Data'!D2:D174 === 'Good (2)',     'Indiviual FS Data'!D2:D174 === 'Outstanding (1)',     'Indiviual FS Data'!D2:D174 === 'Requires Improvement (3)',      'Indiviual FS Data'!D2:D174 === 'Inadequate (4)'   )=,   C3+1, C3 )This may not make sense as you can't see the spreadsheet.I have some very minor knowledge of programming concepts but I don't have any experience with this or similar in Excel.
Add 1 if there is data in cell
google spreadsheets;formulas