Forum Discussion
Copying a formula with table reference.
Hi I want to copy this formula to the right: =SUMIFS(Tabell1[Tilbudssum];Tabell1[Selger];$B$2;Tabell1[Periode mottatt tilbud];">="&DATE(YEAR($B$1);MONTH($B$1);1);Tabell1[Periode mottatt tilbud];"<="...
If you introduce a defined name to reference a table column, that will be treated as an absolute reference. For the basic table, dragging the formula to the right will create relative referencing but duplicating the formula by selecting a range and using Ctrl/Enter to commit the new formulas will also be absolute. It is not just you, it is confusing.
