1 OFFSET FORMULA, I'M NOT SURE WHAT DOES IT MEAN!!!!!!

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

Guest

Hi, I have this formula, I understand everything but after *sum(offset...etc)
I get lost, does anybody know how to read it, what is that 0 means?>
Thank you so much!!!

=IF(Pct_of_FC?=TRUE, of_FC*SUM(OFFSET(W5,Lag__mos,0,Lag__mos)))
 
It means that W5 is offset 0 columns, the zero can also be left out
The rows are offset with whatever is entered in the named cell Lag__mos
and it also picks up the size of the height from that cell. Meaning that if
Lag_mos = 5
then it will sum W10:W14
 
OFFSET(W5,Lag__mos,0,Lag__mos)

W5 is the cell from which the offset is calculated.

Las_mos id a named range and the first occurence specifies the number of
rows down from W5 that offset is i.e the first cell to SUM: if lag_mos=5,
then offset cell is W10. The second occurence is the number of cells to sum,
so our example it is 5:

So the summation is equivalent to SUM(W10:W14)

HTH
 
Back
Top