Counta

[martins]

I am using COUNTA to count data in a range of cells - the data in this
instance is dates formatted as say Jan-06 - should work ok except that
the formula is also counting cells which maybe blank but contain other
formulas - what do I need to do to just return a result for the data as
specified?

 

[Peo Sjoblom]

Are these dates that are numeric? If so use COUNT instead of counta,
otherwise you can use

=COUNTIF(A:A,"*?" )

to count text but not ""


--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com

 

[Max]

I am using COUNTA to count data in a range of cells - the data in this
instance is dates formatted as say Jan-06 - should work ok except that
the formula is also counting cells which maybe blank but contain other
formulas - what do I need to do to just return a result for the data as
specified?

Try SUMPRODUCT with an additional criteria
to exclude cells which are "blank" ("")
something like the term: ... *(A1:A10<>"") ..
within the example formula below:

=SUMPRODUCT((A1:A10=--"7-Jan-2006")*(A1:A10<>""))