Comments on: Google Sheets COUNTIF Not Blank: 4 Easy Ways https://spreadsheetpoint.com/count-cells-if-not-blank-google-sheets/ Google Sheets Tips & Tutorials Wed, 21 Aug 2024 15:35:36 +0000 hourly 1 https://wordpress.org/?v=6.7.1 By: jmarkus https://spreadsheetpoint.com/count-cells-if-not-blank-google-sheets/#comment-13471 Fri, 02 Feb 2024 12:44:25 +0000 https://spreadsheetpoint.com/?p=1081#comment-13471 In reply to Julie.

Hard to tell without looking at your specific sheet, but maybe try these?

  • Check for hidden characters or spaces: =COUNTA(ARRAYFORMULA(TRIM(P10:P288)))
  • Remove non-printable characters: =COUNTA(ARRAYFORMULA(CLEAN(P10:P288)))
  • Ensure consistent data types: =COUNTA(ARRAYFORMULA(VALUE(P10:P288)))
  • Manually inspect cells for hidden content.
  • Check for merged cells and unmerge if necessary.
]]> By: Julie https://spreadsheetpoint.com/count-cells-if-not-blank-google-sheets/#comment-11612 Fri, 09 Jun 2023 17:24:16 +0000 https://spreadsheetpoint.com/?p=1081#comment-11612 I’ve tried all the count formulas to count only fields containing text, but it is pulling a greater number than it should.

I did =COUNTIF(P10:P288, “”) and it pulled “4” the correct number should be 3
I also did =COUNTA(P10:P288) and it also pulled 4. I checked for hidden rows, but everything is expanded. I also deleted all information in that entire row and the formula pulled “1” after everything was removed. Help! What am I doing wrong?

]]> By: Amanda https://spreadsheetpoint.com/count-cells-if-not-blank-google-sheets/#comment-904 Fri, 07 Aug 2020 14:49:58 +0000 https://spreadsheetpoint.com/?p=1081#comment-904 Thanks, this solved my problem! 🙂

]]>