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.