I have the following formula in A2 of my worksheet:

=SUMPRODUCT((SUMIF('[Master.xlsx]CompositeAssets'!$C:$C,$W$2,'[Master.xlsx]Composite Assets'!L:L)*(SUMIF('[Master.xlsx]CompositeAssets'!$C:$C,$W$1,'[Master.xlsx]Composite Assets'!L:L))))

The only issue is that when I drag down the formula, I need it to reference the next column over in the master spreadsheet. For example, I would need A3 of my sheet to have:

=SUMPRODUCT((SUMIF('[Master.xlsx]CompositeAssets'!$C:$C,$W$2,'[Master.xlsx]Composite Assets'!**M:M)***(SUMIF('[Master.xlsx]CompositeAssets'!$C:$C,$W$1,'[Master.xlsx]Composite Assets'!**M:M**))))

Thanks SO much in advance!!!

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.