S
stagiana
Hello!
I'm trying to calculate a running total in one column of my
spreadsheet. I clicked on the lower right corner of the cell
containing the original formula and dragged it down the column. All
of the cells then populated with the correct formula series...but
every cell displays the result from the first formula, rather than the
result from the formula in its cell.
The formulas that are in the cells are:
=SUM(E3-C4+D4)
=SUM(E4-C5+D5)
=SUM(E5-C6+D6)
=SUM(E6-C7+D7)
=SUM(E7-C8+D8)
Etc...
The results that display in the cells are:
2,142.32
2,142.32
2,142.32
2,142.32
2,142.32
Etc.
I tried to start a new spreadsheet and drag to fill the totals in
there, but it did the same thing - copied the formulas correctly but
displayed them incorrectly. However, if I go into the formula bar and
just hit "enter", it commits the formula poperly and displays the
correct result.
I *can* go into every single cell and commit each result independently
but there are 85 worksheets, each one running more than 200 lines, and
that will just take forever.
I also tried using the right mouse button to select the cells I wanted
to copy the running formula into, and selected "fill", "series", and
that also didn't work.
This workbook was working perfectly yesterday. I grouped a bunch of
the sheets to print them right before I left work, and then when I
closed the file, I must have inadvertently committed some change that
shouldn't have been committed - but I've been racking my brain all
morning and haven't the slightest idea *what* that could have been.
Please help a poor girl retain some sanity!
Stacy
I'm trying to calculate a running total in one column of my
spreadsheet. I clicked on the lower right corner of the cell
containing the original formula and dragged it down the column. All
of the cells then populated with the correct formula series...but
every cell displays the result from the first formula, rather than the
result from the formula in its cell.
The formulas that are in the cells are:
=SUM(E3-C4+D4)
=SUM(E4-C5+D5)
=SUM(E5-C6+D6)
=SUM(E6-C7+D7)
=SUM(E7-C8+D8)
Etc...
The results that display in the cells are:
2,142.32
2,142.32
2,142.32
2,142.32
2,142.32
Etc.
I tried to start a new spreadsheet and drag to fill the totals in
there, but it did the same thing - copied the formulas correctly but
displayed them incorrectly. However, if I go into the formula bar and
just hit "enter", it commits the formula poperly and displays the
correct result.
I *can* go into every single cell and commit each result independently
but there are 85 worksheets, each one running more than 200 lines, and
that will just take forever.
I also tried using the right mouse button to select the cells I wanted
to copy the running formula into, and selected "fill", "series", and
that also didn't work.
This workbook was working perfectly yesterday. I grouped a bunch of
the sheets to print them right before I left work, and then when I
closed the file, I must have inadvertently committed some change that
shouldn't have been committed - but I've been racking my brain all
morning and haven't the slightest idea *what* that could have been.
Please help a poor girl retain some sanity!
Stacy