=SUMPRODUCT(N(INDIRECT("Sheet"&ROW(1:3)&"!A1")),N( INDIRECT("Sheet"&ROW(1:3)&"!B1")))

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)


wrote in message
oups.com...
I am trying to create a weighted average on one sheet calculated from
several other sheets. I need to use the product of just two cells on
each sheet for the weighted average. I know I cant use sumproduct in
3D, is there another way around this problem?

Thanks,

Sarah