Hi,
I have a spreadsheet with a column of week numbers and a column of numbers representing how long a job took to complete in that week.
What I need to know is how many jobs were completed in less than 4 days in a given week.
I've tried the following function
=COUNTIF(D2:D4905, AND(F2:F4905=30, D2:D4905 <4))
where D2:D4905 contains the number of days that a job took to complete (the records to be counted)
F2:F4905 contains the week numbers
So what I thougt I was asking for here is how many jobs in week 30 took less than 4 days to complete, but all I get back is 0. There are actually 95 records to be counted.
Thanks in advance
Jude
I have a spreadsheet with a column of week numbers and a column of numbers representing how long a job took to complete in that week.
What I need to know is how many jobs were completed in less than 4 days in a given week.
I've tried the following function
=COUNTIF(D2:D4905, AND(F2:F4905=30, D2:D4905 <4))
where D2:D4905 contains the number of days that a job took to complete (the records to be counted)
F2:F4905 contains the week numbers
So what I thougt I was asking for here is how many jobs in week 30 took less than 4 days to complete, but all I get back is 0. There are actually 95 records to be counted.
Thanks in advance
Jude