I need a formula that changes column automatic

[arntet]

Hi
I have a formula like this:


=IF(A3="";"";SUM(Inndata!B$3:B$100))

When I expand the formula down to the next cell I want it to look like this:

=IF(A3="";"";SUM(Inndata!C$3:C$100))

How is this possible? Please help

[Ace_XL]

Try

=IF($A$3="";"";SUM(INDEX(Inndata!B$3:AZ$100;;rows(a$1:A1))))

Use relative reference for $A$3 i.e. A3 if you want it to change to A4 and so on if you copy down

[arntet]

Fantastic! thanks alot!

[Richard Buttrey]

Hi and welcome to the forum

One way - assuming you enter the formula in A4 is

=IF(A3="";"";SUM(OFFSET(Inndata!B$3:B$100,0,ROW()-4)))

If not on row 4 then change the ROW()-4 bit to reflect the row it is on. e.g. if Row 10 then Row()-10....etc.