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.
=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.