Counta

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

martins - 03 Apr 2006 23:40 GMT

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?

Signature

martins

Reply to this Message

Peo Sjoblom - 03 Apr 2006 23:53 GMT

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

Signature

Regards,

Peo Sjoblom

http://nwexcelsolutions.com

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

Reply to this Message

Max - 04 Apr 2006 00:04 GMT

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

Signature

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

Reply to this Message