Forum Discussion

fridtjof1270's avatar
fridtjof1270
Copper Contributor
Oct 06, 2024

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];"<="&EOMONTH(DATE(YEAR($B$1);MONTH($B$1);1);0))

Problem is that the tablerefrences changes for every kolumn it goes? hope u understand...

Excel
Formulas and Functions
  • HansVogelaar's avatar
    HansVogelaar
    MVP
    Oct 06, 2024

    fridtjof1270 

    If you want to keep [Periode mottatt tilbud] fixed, replace both instances of

    Tabell1[Periode mottatt tilbud]

    with

    Tabell1[[Periode mottatt tilbud]:[Periode mottatt tilbud]]

  • PeterBartholomew1's avatar
    PeterBartholomew1
    Silver Contributor
    Oct 06, 2024

    fridtjof1270 

    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.

Resources