If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Counting with two criteria where one is between values
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! |
#2
|
|||
|
|||
Counting with two criteria where one is between values
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! |
Thread Tools | |
Display Modes | |
|
|