Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Referencing Across Sheets Based On Condition
Hi All,
I've a Issue with framing a fomula for the below Scenario in Excel: 1) I have 1 row which has week number like 40-06, 41-06, etc... in one row which keeps repeating for all pass fail block column for 7 days.1 2) I have 1 row below which has Pass, Fail, Block which repeats for every day as column heading. 3) The above is for a daily bais and for every month, so 12 sheets with 30 sets of pass fail block column and each column above has the week number as mentioned above. The Problem: I would like to calculate the weekly report for the same group that is pass fail block based on the week number and the pass fail block criteria. The problem is because some days in a week will have 2 days in one month and the balance in next month. Could u please suggest a formula or method for the above. It is Urgent |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
copy data from 1 worksheet to another based on a condition | Excel Worksheet Functions | |||
how do I create a pivot table based on multiple sheets | Excel Discussion (Misc queries) | |||
Calculation based on a condition | Excel Worksheet Functions | |||
populating sheets based on data from parent sheets | Excel Discussion (Misc queries) | |||
make a cell empty based on condition | Charts and Charting in Excel |