Posted 1/6/2023 08:12 (#10025099 - in reply to #10023368) Subject: RE: excel question
That happens to me if/when I add- or delete- cells - or columns - after I created the formulas. That might be what you did as well - create a formula.... then changed the spreadsheet by adding or deleting something....
When you write a formula, "C4" doesn't always mean cell C4. It references the cell in the third column from the left, and fourth cell down from the top. When you add or delete cells - or columns - all this shifts, depending on whether you added or deleted.
The answer to this is to write your formulas using the "$" .
$C$4- will always take you to cell C4.
$C4 - will always take you to row C, and to the 4th cell from the top
C$4 - will take you to the third row from the left, and the 4th cell.
I don't know if this is clear to you, or seems muddy. However, I think this is the answer to your dilemma.
Here is a suggestion: open a blank spreadsheet. Create some columns and rows with data. At the bottom, create a cell to sum the total. Do a "Fill Right" with this formula. See what happens with the formula. Then go back and change the formula to include the "$" in the formula, and see how it changes what is totaled. This should help you understand how this works.