Forum Discussion
Sumproduct formular not working as expected
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.
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.
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.
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.
derick1560 I see, perhaps it's time to update the workbook.