The user in this Reddit post has run into a classic spreadsheet frustration, and the root cause is a simple misunderstanding of how the dollar sign works. They locked only the column with `$B18`, expecting the row to change freely when dragging the formula across columns. Instead, the row stayed locked too, and the formula failed to produce the expected values from C32 and D32. Their confusion is understandable, but it reveals a deeper truth: traditional spreadsheet tools force you to think like a programmer about absolute and relative references, when what you actually want to do is just tell the tool what to calculate.
Here is what happened technically. In a standard spreadsheet, `$B18` absolutely locks the column B but leaves the row 18 relative to the formula's position. When you copy that formula to the right, the column stays B, and the row stays 18 only if the original formula was also in row 18. The user's formula in B34 referenced `$B18`, and when copied to C34, it remained `$B18`, not `$C18` as they intended. The row did not change because the relative row reference (18) was already anchored to the formula's starting row. To get both the column and the row to shift, you would need no dollar signs at all: `B18`. To lock only the column but let the row increment, you would need `$B18` only if the formula were being copied *down* rows, not across columns. The user needed `B$18` to lock the row while allowing the column to change, or no locking at all if the structure was a simple horizontal drag.
This is not a user error, it is a design limitation. The dollar sign syntax is a holdover from the 1980s, and it forces you to mentally map out a grid of relative and absolute positions before you write a single formula. For a user who simply wants to sum B32, C32, and D32 across columns, this abstraction is an unnecessary cognitive tax. The real takeaway here is that spreadsheets should not require you to master cryptic syntax just to copy a formula horizontally. An AI-native spreadsheet would let you describe the intent: "for each column, take the value from row 32 in the same column." The tool would handle the reference logic automatically, freeing you to focus on the data, not the notation. That is the transformation worth exploring, not memorizing when to put a dollar sign in front of the row versus the column.