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