Counting with two criteria where one is between values

  • Thread starter Thread starter Fluffygoldfish
  • Start date Start date
F

Fluffygoldfish

Hi

I have a spreadsheet with details of client contacts.
Column H - users enter "X" when client has had first appointment
Column I - users enter time (in weeks) client has waited for the appointment

I need to return how many clients waited 0-8 weeks, 9-13weeks and 13-18 weeks

I can count how many waited <8 weeks using
=SUM((H1:H5="X")*(I1:I5<=8))

How can I count with the first criteria being an X in column h and the
second criteria being between the values of 9 and 13?

Thanks very much to anyone who is able to help me, it is very much
appreciated!
 
Hi,

=SUMPRODUCT(($H$1:$H$5="X")*($I$1:$I$5>=9)*(I1:I5<=13))

change range to fit your needs
 
Back
Top