Have you tried COUNT() instead of COUNTA()?



isofuncurves wrote:
Andy,

Thank you. That is exactly what I was looking for. I do have one
ploblem with the solution though. My data table contains formulas to
generate the chart data. So CounA() is not working for me. Each cell,
inclulding the "empty ones" contains a formula:

I am defining my series by:

=OFFSET('CIP CMG'!$G$3,0,0,COUNTA('CIP CMG'!$G:$G)-1)
=OFFSET('CIP CMG'!$I$3,0,0,COUNTA('CIP CMG'!$I:$I))
=SERIES('CIP
CMG'!$H$3,Metrics.xls'!CIP_Date,Metrics.xls'!Sum _Target_Start,2)


The data for the named ranges is not entered manually. It is generated
by a formula.

=IF(G21<=TODAY(),COUNTIF(C$2:C$91,"<"&$G21),"" )


I assume COUNTA does not work because the cells are non-empty. Any
ideas how to make this work with formulas in the cells?

thanks,
Carl.



--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info