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