brianfosterblack
Active Member
- Joined
- Nov 1, 2011
- Messages
- 251
I have a range of cells in which each cell has a formula. the formula will result in ether text being entered in a cell or leave it blank (in other words ="")
I want to count all the cells which are not blank and all will have text or dates in them - no numbers
If I use
It counts the blanks and I get an answer of 4 when only 1 cell has text in.
If I use
I get the correct answer of 1
However I want to enter the formula to extend up to column B28 for staff who will later use these columns to enter more date but in this case the second formula does not work as there are many more blank cells
Can anyone please help.
I want to count all the cells which are not blank and all will have text or dates in them - no numbers
If I use
Excel Formula:
counta(B3:B6)
If I use
Excel Formula:
counta(B3:B6)-countif(B3:B6,"")
However I want to enter the formula to extend up to column B28 for staff who will later use these columns to enter more date but in this case the second formula does not work as there are many more blank cells
Can anyone please help.