Text Formula Error

[Christopher Naveen]

Hi,

I use text formula and after saving the file using pastespecial to values I
can see a single quote (') in the blank cells. This is giving a problem to
CountA function.

Ex :

IF(WEEKDAY(A1,1)<=5,TEXT(A1,"DD-MM-YY"),"")

Using the above formula, if the condition is false it will show as blanks.
In the blank cell I am getting the output as single Quotes (').
Now I am trying to find out the count of non blanks in this col using countA
and it is counting all the blank cells also as it contains single quotes.

Can anybody help me to solve this

Christ

 

[Max]

COUNTA will count cells containing formulas, regardless of returns
You can use sumproduct, eg:
=SUMPRODUCT(--(A1:A4<>""))
Adapt the range to suit
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:17,800 Files:359 Subscribers:56
xdemechanik