use of countif()

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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"))
 
Try this

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

replace ">1" with whatever your criteria is
 
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
 
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. )
 
Back
Top