Date and Days list problem

W

Wendy

Hi

I have a list of data

Date received, area id, date processed,target days its for the whole month
which means data can be repeated for each area on a different date.

I need to find how many target days for each area id =<3 days, >3 and <7
and >7. It sounds easy but all I'm getting is a headache!


Can anyone point me in the right direction please?

Thanks

Wendy
 
S

Sean Timmons

I would add a column to calculate each row, something like, =date processed -
date received.
Then, in your <= 3 days, enter, =countif(calculated column,<=3)
And, in the >3 <7 put =sumproduct(--(calculated rows < 7),--(calculated rows
3))
Click to expand...
and in >7 put =countif(calculated column,>7)

Although, one of those will probably want to be either >=7 or <=7...
 
S

Sean Timmons

One other important note... for the sumproduct portion, do not select the
entire column. It doesn't like that kind of thing. Select the range of rows
you want to evaluate...
 
Top