Counta
 

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?


--
martins
------------------------------------------------------------------------
martins's Profile: http://www.excelforum.com/member.php...o&userid=31616
View this thread: http://www.excelforum.com/showthread...hreadid=529414

Counta
 

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




"martins" wrote in
message ...

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?


--
martins
------------------------------------------------------------------------
martins's Profile:
http://www.excelforum.com/member.php...o&userid=31616
View this thread: http://www.excelforum.com/showthread...hreadid=529414

Counta
 

"martins" wrote:
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<""))

--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---