Forum Discussion
Solved
Formula changes when a row is inserted
When I insert a row anywhere, but normally between row 2 and row 3 to add a new row to fill to keep the most current first. This formula which should be as shown: =SUMPRODUCT($F$2:$F$49*(INT($A$2:$A...
Change the formula in J2 to
=SUMPRODUCT([Carbs]*([Date]=[@Date]))
or better, to
=SUMIF([Date],[@Date],[Carbs])
and fill down.
I don't know - I'd have to see your revision of the workbook.
It is the same one I sent to you.
But the one attached to the first post in this discussion has not been modified.
- I guess I don't understand. Did you not make a copy of the one I uploaded. Then it would be a copy of the one which was having the issue described. I guess it doesn't matter now. You got it working on the one you sent me. When I enter a new function or modify a function, I then select the green check mark to save the function. It usually updates the column automatically. The then that perplexes me is, it will then ask to update the column, after it is already done it. Other times I will get the message of inconsistent functions, even though I cannot see any difference from one cell to the next.