Alternative to COUNT function

[Daniel]

Hello everyone,

In access I have set up some code that writes a recordset
into excel, and then does some simple analysis in excel
including counts. Orginally I was using office 97, and
when I used counts on peoples ids it worked fine.

However using office 2003 the data - the id's are written
into excel as text so my counts don't work...I actualy
didn't know you can't count on text fields! Does anybody
know how to do a simple count when the values are written
as text?

Daniel

 

[Frank Kabel]

Hi Daniel
try COUNTA

 

[Guest]

You could use countblank function. EG if you have say 200
approx lines of text in column A then the formula is =300-
countblank(a1:a300)will give the answer of 200 non blanks.

Hope this helps.

Paul