View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Roger Govier[_3_] Roger Govier[_3_] is offline
external usenet poster
 
Posts: 2,480
Default counting data in columns with linked cells

Hi Bernie

Because you have a formula in the cell which pulls data from another sheet,
Counta is counting this.
As the results of the formula, when true, will be dates which will be serial
numbers, try
=COUNTIF(A:A,"0")

--
Regards
Roger Govier

"Bernie R." <Bernie wrote in message
...
I have a spreadsheet with numerous columns of data containing dates linked
from other spreadsheets. I'm using the "counta" to count the rows
containing
data in each column, but my problem is every row is being counted whether
it
contains data or is blank.

Appreciate anyone's assistance in solving this.