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

"Fluffygoldfish" wrote:

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