Date and Days list problem

[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

 

[Guest]

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

and in >7 put =countif(calculated column,>7)

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

 

[Guest]

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