| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
linked worksheet formulas
I am trying to put a total value into a linked worksheet. This value has a
date condition as well as a description condition. I have tried =DSUM('cat12-Dec04-Oct-05'!A6:V30550,"LightsOn",'cat12-Dec04-Oct-05'!U5:U5) and =SUM(IF(('cat12-Dec04-Oct-05'!A8:A30553="12/1/2004")+('cat12-Dec04-Oct-05'!U8:U30553="Sustain"),('cat12-Dec04-Oct05'!P2:P30547))) neither work can someone help me? Thanks Laura Wild Calgary, AB |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| copy formulas to different cells in another worksheet | Excel Discussion (Misc queries) | |||
| Can cells containing linked formulas be identified? | Excel Discussion (Misc queries) | |||
| How do I remove empty chart plots from linked worksheet charts | Charts and Charting in Excel | |||
| Relative worksheet reference in 3-D formulas? | Excel Worksheet Functions | |||
| Way to make Excel only run certain formulas on a worksheet? | Excel Discussion (Misc queries) | |||
Threaded Mode
