Caly
Board Regular
- Joined
- Jul 19, 2015
- Messages
- 159
- Office Version
- 365
- 2013
- 2011
- 2010
- 2007
- Platform
- Windows
I have a formula in a cell that will return either data or leave the cell blank. I want to do a count that will show the number of lines that has data but when I do this, the formula includes the cells that are blank. How can I exclude those? I think it is because the formula doing the count thinks there is data since it is a formula and it is not hard coded.
Formula in the cell is
=if(A1=“Yes”,”Yes”,””)
the formula to do the count is below but it includes the blank cells
=countif($A$1:$A$3,”<>”)
Formula in the cell is
=if(A1=“Yes”,”Yes”,””)
the formula to do the count is below but it includes the blank cells
=countif($A$1:$A$3,”<>”)