Countif functions

  • Thread starter Girl Scout Sale Manager
  • Start date
G

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!
 
A

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
[email protected]> 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
Click to expand...
bunch!
 
Top