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 want to keep [Periode mottatt tilbud] fixed, replace both instances of
Tabell1[Periode mottatt tilbud]
with
Tabell1[[Periode mottatt tilbud]:[Periode mottatt tilbud]]