Elad Benda
Reputation: 36656
how to count the non value and non formula cells?
I'm trying this formula to count the blank cells, and I get "NEW" as if there are none-blank - regardless if there is data in the first cell or not.
How can I fix this?
=IF(AND(ARRAYFORMULA(ISBLANK(AB8:AB9)+ISNA(AB8:AB9))), "SAME", "NEW")
Upvotes: 0
Views: 45
Answers (2)
MattKing
Reputation: 7773
=IF(COUNTA(AB8:AB9),"NEW","SAME")
Seems that you should just count the values and if it's 0 then it should display "SAME"
Upvotes: 0
Elad Benda
Reputation: 36656
An empty string (“”) can be a result of a formula while apostrophe is often used by many people during data entry.
https://productivityspot.com/count-non-blank-cells-google-sheets/
Upvotes: 0
Related Questions
- Count of Non Formula Cells in a column
- Formula to return the number of nonblank cells in each row in a range
- Excel count non emtpy cells
- Count rows, which have not blank cells
- Count values without having to specify each
- Google spreadsheet countif non empty cells except certain values
- Get Count of Cells used in Excel Formula
- CountIf blank cells and formulas
- How to count cells that only contain the VALUE 0 and not the result of a formula?
- Using Excel Formulas to return the count of non zero in a column