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

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 have a column of numbers, some positive, some negative.
 

On Mar 23, 8:09*am, Skip wrote:
I would like to count the number of entries that are 3 and are <=7.
What function would I use? *Thanks for any help.

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 have a column of numbers, some positive, some negative.
 

On Mar 23, 6:09*am, Skip wrote:
I would like to count the number of entries that are
3 and are <=7. What function would I use?

One way:

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

More straight-forwardly:

=SUMPRODUCT((A1:A1003)*(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.

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

On Mar 23, 1:11*pm, joeu2004 wrote:
On Mar 23, 6:09*am, Skip wrote:

I would like to count the number of entries that are
3 and are <=7. *What function would I use?

One way:

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

More straight-forwardly:

=SUMPRODUCT((A1:A1003)*(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.

Thanks, SUBPRODUCT works great. Thanks again