Countif functions

[Girl Scout Sale Manager]

I need to calculate a countif function using two criteria. My range is
q2:q36. I need the function to count the number of times the values in those
cells are >69 and at the same time are also <100. I am having a hard time
with this one. Please be very detailed with your answer....thanks a bunch!

 

[JulieD]

Hi

two options
=COUNTIF(Q2:Q36,">"&69)-COUNTIF(Q2:Q36,">="&100)
or
=SUMPRODUCT(--(Q2:Q36>69),--(Q2:Q36<100))

Cheers
JulieD


"Girl Scout Sale Manager" <Girl Scout Sale
(e-mail address removed)> wrote in message
news:[email protected]...

 

[Arvi Laanemets]

Hi

=SUMPRODUCT(--(Q2:Q36>69),--(Q2:Q36<100))
or
=SUMPRODUCT((Q2:Q36>69)*(Q2:Q36<100))


Arvi Laanemets

"Girl Scout Sale Manager" <Girl Scout Sale
(e-mail address removed)> wrote in message

I need to calculate a countif function using two criteria. My range is
q2:q36. I need the function to count the number of times the values in those
cells are >69 and at the same time are also <100. I am having a hard time
with this one. Please be very detailed with your answer....thanks a

bunch!

 

[JulieD]

glad to assist & thanks for the feedback

Julie and Arvi----
Thank you soooooooooooooo much!!!! That did the trick!!!!!!!