I have a column of numbers, some positive, some negative.

  • Thread starter Thread starter Skip
  • Start date Start date
S

Skip

I would like to count the number of entries that are >3 and are <=7.
What function would I use? Thanks for any help.
 
I would like to count the number of entries that are >3 and are <=7.
What function would I use?  Thanks for any help.
Click to expand...

In xl 2007 look in the help index for countIFS. In less than xl 2007
look in the help index for COUNTIF and AND
 
I would like to count the number of entries that are
Click to expand...

One way:

=COUNTIF(A1:A100,"<=7")-COUNTIF(A1:A100,"<=3")

More straight-forwardly:

=SUMPRODUCT((A1:A100>3)*(A1:A100<=7))

=COUNTIFS(A1:A100,">3",A1:A100,"<=7")

The last one is the best. But it is available only in XL2007 and
later.

In the SUMPRODUCT, multiply (*) acts like AND. We cannot use AND in
that context.
 
One way:

=COUNTIF(A1:A100,"<=7")-COUNTIF(A1:A100,"<=3")

More straight-forwardly:

=SUMPRODUCT((A1:A100>3)*(A1:A100<=7))

=COUNTIFS(A1:A100,">3",A1:A100,"<=7")

The last one is the best.  But it is available only in XL2007 and
later.

In the SUMPRODUCT, multiply (*) acts like AND.  We cannot use AND in
that context.
Click to expand...

Thanks, SUBPRODUCT works great. Thanks again
 
Back
Top