Date and Days list problem
 

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

Date and Days list problem
 

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

"Wendy" wrote:

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

Date and Days list problem
 

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

"Wendy" wrote:

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