Hello guys, I hope you are doing well!
I have a question for which I am not sure how I am supposed to put it in words, but I will try.
So I have this table (screenshot attached), and the first object in LINE 2 (i.e. January), is based on the three previous cells (OCT, NOV, and DEC in LINE 1).
The equation for cell B3 is as follows:
(M2 * $B$5) + (L2 * $B$6) + (K2 * $B$7).
BUT, when I copy the formula into the next cell (C3), the cell values the formula refer to become M2, N2, and O2 - since the formula assumes there are values in those cells.
How can I write my equation so that when I COPY the formula in cell B3 into cell C3 through cell M3, the cell values will refer to previous cells and not following cells?
In other words, C3 will be = (B3 * $B$5) + (M2 * $B$6) + (L2 * B$7$)...and so on for each cell from C3 to M3?
I am sorry if it's a bit confusing - I tried my best
Bookmarks