Hi

Here's a start for you. Put the code below into a general module in the relevant workbook.

Assumptions.

1) This function will be called from the first sheet in the workbook.
2) It will cycle through all the other sheets in the workbook, starting from sheet2.
3) Call the function in the first sheet as
=mysumproduct(A8,H3,L3,"G2:G500")

If you only have 2 sheets in your workbook (the first sheet and one other) then this should return the same result as the sumproduct formula. If you have more than 2 sheets, it should return the 3D result.


HTH

rylo