Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sumproduct from different worksheet
Worksheet to input formula: Exception Sheet
Worksheet containing data to find/sum: Overall I want to find on the Overall worksheet in column B any text beginning with Cl and in column D any number matching the number I type on the Exception sheet in C2 . Then I want to match those finding against the number of days in shop, column H, of the Overall worksheet, and sum the days in shop. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Protect Workbook vs Worksheet?? | Excel Worksheet Functions | |||
Inserting Filtered RC cell information into other worksheets | Excel Discussion (Misc queries) | |||
Copy from worksheet to another x times | Excel Discussion (Misc queries) | |||
Worksheet Function - Find? | Excel Worksheet Functions | |||
copyright and worksheet protection | Excel Discussion (Misc queries) |