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…
HiI 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… Read More