Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
I have three sheets in my workbook: Request sheet with request number
and date,Fault sheet with request number and faults count,and in the third sheet I have month start date and end date. I want to retrieve data such that : sum of all the faults of those requests which fall in the month given in third sheet Request Sheet Request ID ActualEnd Date 1 1/22/2006 2 2/27/2006 3 1/22/2006 4 1/22/2006 5 1/22/2006 Fault Sheet Request ID Total 1 6.75 2 3.75 3 7.50 third sheet Jan-06 1/1/2006 1/31/2006 to get value |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
From several workbooks onto one excel worksheet | Excel Discussion (Misc queries) | |||
Printing data validation scenarios | Excel Worksheet Functions | |||
Sort pages? | Excel Discussion (Misc queries) | |||
External Data | Excel Discussion (Misc queries) | |||
Returning data to Excel sheet from MS query | Excel Discussion (Misc queries) |