dsum help

[plain]

in the database field, can i use the range from multiple worksheets from the same workbook ? example :
=DSUM(Sheet1:Sheet2!A1:C4,3,Sheet3!A1:A2)
the above function returns "#value!".

but with the same data, the returns show the correct values if i use these functions :
=DSUM(Sheet1!A1:C4,3,Sheet3!A1:A2)
or
=DSUM(Sheet2!A1:C4,3,Sheet3!A1:A2)

thank you for your help.

 

[Aladin Akyurek]

in the database field, can i use the range from multiple worksheets from the same workbook ? example :
=DSUM(Sheet1:Sheet2!A1:C4,3,Sheet3!A1:A2)
the above function returns "#value!".

I don't believe so. DSUM is not a 3D-function.

but with the same data, the returns show the correct values if i use these functions :
=DSUM(Sheet1!A1:C4,3,Sheet3!A1:A2)
or
=DSUM(Sheet2!A1:C4,3,Sheet3!A1:A2)


That's right. You can do of course the following:

In E2 in Sheet1 enter:

=DSUM(A1:C4,3,Sheet3!A1:A2)

In E2 in Sheet2 enter:

=DSUM(A1:C4,3,Sheet3!A1:A2)

In Sheet3,

in B2 enter:

=SUM(Sheet1:Sheet2!E2)
This message was edited by Aladin Akyurek on 2002-05-05 23:33

 

[plain]

Appreciate your clarification and suggestion.

Tks again.