using 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




"martins" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>

[Max]

"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
---