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.
What function would I use? Thanks for any help.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
D
Donald Guillett
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
J
joeu2004
I would like to count the number of entries that are
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.
S
Skip
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.
Thanks, SUBPRODUCT works great. Thanks again