COUNTIF Statment - multiple variables

[juliewine]

I have a list of employee ages that need to be in chart form based on
certain age range. Ex., 20-29, 30-39, 40 -49.

I am trying to do a COUNTIF statement that would count all the ages i
a particular category. Ex., COUNTIF (D112,"<=30"). This works fin
excpet that I need it to count <=30 and >20.

Any ideas on how to do this? Or is there an easier way to put thi
information into chart form?

Thank you for your help.

Juli

 

[Frank Kabel]

Hi Julie
try
=SUMPRODUCT(--(D112>20),--(D112<=30))

or
=COUNTIF(D112,"<=30")-COUNTIF(D112,"<=20")