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