C
Chad Portman
I am having issues with the following formula:
=SUMPRODUCT(('MCO '!$D$2:$D$3000=B$3)*('MCO '!$E$2:$E$3000=$A7))
But if I run this formula and say the data stops at row 600. It changes the
fomula to the following:
=SUMPRODUCT(('MCO '!$D$2:$D$600=B$3)*('MCO '!$E$2:$E$600=$A7))
I thought about trying to using indirect to fix this but can not make it
work any ideas.
=SUMPRODUCT(('MCO '!$D$2:$D$3000=B$3)*('MCO '!$E$2:$E$3000=$A7))
But if I run this formula and say the data stops at row 600. It changes the
fomula to the following:
=SUMPRODUCT(('MCO '!$D$2:$D$600=B$3)*('MCO '!$E$2:$E$600=$A7))
I thought about trying to using indirect to fix this but can not make it
work any ideas.