Forum Discussion
Solved
Sumproduct formular not working as expected
I have modified a sumproduct formula and it is not working as expected. =SUMPRODUCT((Sales!B$3:B$999=A6)*(Sales!F$3:F$999)) It was previously =SUMPRODUCT((Sales!B$3:B$600=A6)*(Sales!F$3:F$600)) ...
You have blank cells in column B of Sales for these rows, thus formula returns nothing. I'm not sure why do you have dates both in columns A and B, but you shift on column A in formula it returns correct result.
Please specify the result of your modified formula and the result you expected from it.
Can I send the excel file? It would be easier to understand.