help with formula to calculate what column to use

[bobh]

Hi All,

I have a need to figure out which column to use in a formula and I'm
not able to figure it out so hopefully someone here can help.

what I have/know
in this company the fiscal yr starts oct, ends sept, on the
spreadsheet I have
starting column C thru N, row 6
Oct, Nov, Dec, Jan, Feb, Mar, Apr, May, Jun, Jul, Aug, Sep

on the 1st business day of each month the prior months data is added
so this being june right now the data going across columns c thru n
would look like
12, 45, 36, 73, 22, 71, 29, 55, 0, 0, 0, 0
23, 32, 43, 56, 65, 57, 39, 0, 0, 0, 0, 0

in column Q of each row I'm looking for a formula that will determine
that last month(this being june) was May and May is column J and then
change itself to use column J & rownbr.

so if in column Q I had from last months run I7-P7 then this being
june the change would be J7-P7

hope I made sense
bobh.

 

[Ron Rosenfeld]

Hi All,

I have a need to figure out which column to use in a formula and I'm
not able to figure it out so hopefully someone here can help.

what I have/know
in this company the fiscal yr starts oct, ends sept, on the
spreadsheet I have
starting column C thru N, row 6
Oct, Nov, Dec, Jan, Feb, Mar, Apr, May, Jun, Jul, Aug, Sep

on the 1st business day of each month the prior months data is added
so this being june right now the data going across columns c thru n
would look like
12, 45, 36, 73, 22, 71, 29, 55, 0, 0, 0, 0
23, 32, 43, 56, 65, 57, 39, 0, 0, 0, 0, 0

in column Q of each row I'm looking for a formula that will determine
that last month(this being june) was May and May is column J and then
change itself to use column J & rownbr.

so if in column Q I had from last months run I7-P7 then this being
june the change would be J7-P7

hope I made sense
bobh.

If I understand you correctly, try:

=SUM(OFFSET(C7,0,0,1,MOD(MONTH(TODAY())+2,12)))

 

[bobh]

If I understand you correctly, try:

=SUM(OFFSET(C7,0,0,1,MOD(MONTH(TODAY())+2,12)))- Hide quoted text -

- Show quoted text -

Thanks, I'll give it a try
bobh.