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