Forum Discussion
Using OFFSET formula to create dynamic print area when cells contain formulas?
Good afternoon, Looking for help. I'm trying to set up a dynamic print area using OFFSET but, for the sheet I'm trying to print, all cells contain formulas so I've used IF and IFERROR to make th...
You formula counts all rows not exactly since cells have formulas, but since they are not blank. Any formula returns some value, empty string returned is also the value of text type.
To count cells ignoring cells with empty texts you may use something like
=SUMPRODUCT(--(F:F<>""))