Created attachment 135877 [details] Spreadsheet to resolve backups I have a spreadsheet that counts NON blank cells. It works in 5.3.4.2 but counts ALL cells in 5.4 Syntax example is: =COUNTIF(D24:N24,"<>""") I have attached the spreadsheet. Delete a 'Y' and the counts go up to 11.
Your formula does not count non-blank cells, it ("<>""") counts cells where the content is unequal to " a double quote. Note that within an inline literal string constant two double quotes "" represent one escaped double quote. 5.4 changed how empty cells are treated, ie. they are counted for "equals empty" ("=") or "not-equals not-empty" ("<>X") like other spreadsheet applications do. To count non-empty cells your formula should have "<>" as criteria argument, eg. =COUNTIF(D24:N24,"<>") Or compare to Y in your case, =COUNTIF(D24:N24,"=Y")