Sumproduct formular not working as expected

[derick1560]

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))

It is not picking up any value after row 600 in the range.

Any help appreciated.

Thanks

[#2]

Please specify the result of your modified formula and the result you expected from it.

[#3]

Can I send the excel file? It would be easier to understand.

[#4]

@Twifoo 

The formulae are on the Gasoline recon sheet range E6 to E36. I

The should be picking up results from column F of the Sales sheet.

Since I modified the formula to include rows 601 to 999. It is not picking up those values

Thank you.

[#5 · Accepted solution]

@derick1560 

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.

[#6]

@Sergei Baklan 

Thank you. Am almost embarrassed. I created the workbook more than 10 years ago and forgot the formula was looking for the values in column B and not column A.

Thanks again.

[#7]

@derick1560 I see, perhaps it's time to update the workbook.