=SUM(OFFSET(D14,,,1,D24))

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

In this formula here

=SUM(OFFSET(D14 ,,, 1,D24)

Am I correct in saying that the 3 commas are acting as E16, F16 and G16

and if I wanted to cover H16 in my formula, I would simply add another comma

Thank

Alby
 
No you are not correct, the commas are delimiters,
the formula ca be written

=SUM(OFFSET(D14,0,0,1,D24))

where the first 0 tells how many rows from D14 it will offset,
the second how many columns, i stands for 1 row in height and D24 tells that
the width will be what's the number in D24 is, so if D24 holds 5 it will sum
5 columns from column D.

=SUM(D14:H14)

should yield the same result
 
Recalling your earlier post...

Why do you shy away from:

=SUM(D14:INDEX(D14:H14,D24))

which is faster than a formula with OFFSET.
 
Why is INDEX faster than OFFSET?


Aladin Akyurek said:
Recalling your earlier post...

Why do you shy away from:

=SUM(D14:INDEX(D14:H14,D24))

which is faster than a formula with OFFSET.
Click to expand...
 
OFFSET is a volatile function, INDEX not. The former therefore will cause
prolonged recalc times.
 
Back
Top