Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Report Date - Date Recv = Days Late, but how to rid completed date | Excel Worksheet Functions | |||
excel date scheduling not msProject | Excel Worksheet Functions | |||
Fomula for number of days on each month from a date range | Excel Discussion (Misc queries) | |||
auto updating list | Excel Worksheet Functions | |||
Adding XY days to date in cells | Excel Discussion (Misc queries) |