use of countif()

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

nikos - 27 Jun 2007 18:50 GMT

Hi.

Does anyone knows how can apply the countif() function partial? (for ex. If
i have the column A10:A100 to apply countif() in the follow cells A54, A67,
A72:A79 , A87, A91:A95, A98.)
If that impossible, any other idea?
Thanks.

Reply to this Message

Don Guillett - 27 Jun 2007 19:56 GMT

One way
=SUMPRODUCT(COUNTIF(INDIRECT({"a2","a5","a8","e10"}),"a"))

Signature

Don Guillett
SalesAid Software
dguillett1@austin.rr.com

> Hi.
>
[quoted text clipped - 5 lines]
> If that impossible, any other idea?
> Thanks.

Reply to this Message

ShaneDevenshire - 27 Jun 2007 20:12 GMT

Hi,

First, tell us what you are counting, ie. countif(myRange,3). Countif does
not allow noncontiguous ranges so you will need to do this another way, if
you tell us what you are counting, such as all items in the range which
contain the word RED, then we will be more help.

For example:
If you add an entry to column B for the cells you want to count in column A,
then:

=SUMPRODUCT((A10:A100>2)*(B10:B100="t"))

Signature

Thanks,
Shane Devenshire

> Hi.
>
[quoted text clipped - 3 lines]
> If that impossible, any other idea?
> Thanks.

Reply to this Message

Peo Sjoblom - 27 Jun 2007 20:42 GMT

You can actually use countif if it is within some other functions

=SUMPRODUCT(COUNTIF(INDIRECT({"A54","A67","A72:A79","A87","A91:A95","A98"}),">0"))

for instance will work if that what was the OP had in mind

Signature

Regards,

Peo Sjoblom

> Hi,
>
[quoted text clipped - 20 lines]
>> If that impossible, any other idea?
>> Thanks.

Reply to this Message

Peo Sjoblom - 27 Jun 2007 20:40 GMT

Try this

=SUMPRODUCT(COUNTIF(INDIRECT({"A54","A67","A72:A79","A87","A91:A95","A98"}),">1"))

replace ">1" with whatever your criteria is

Signature

Regards,

Peo Sjoblom

> Hi.
>
[quoted text clipped - 5 lines]
> If that impossible, any other idea?
> Thanks.

Reply to this Message

nikos - 28 Jun 2007 08:04 GMT

Thank you all for your answers. (What i counting: I have some names in a
column and in adjacent columns there are different data which linked for each
name. So in the last right column i have to check some conditions. Because
the data in columns represent different things i must select non continguous
cells every time across rows. )

> Try this
>
[quoted text clipped - 11 lines]
> > If that impossible, any other idea?
> > Thanks.

Reply to this Message