Sum offset

[Forestq]

Team,

I need to use function like : SUM(OFFSET...


I have some data like:

current month 6

M01 M02 M03 M04 M05 M06 M07 M08 M09 M10 M11 M12 Sum
2 7 4 7 4 3 6 6 1 23 0 6
6 6 45 4 78 6 6 0 0 0 6 0

I have to sum columns (month values) using variable month cell (in this case it will be A1),

please help how to use SUM OFFSET function,

kind regards,
Pawel

 

[Forestq]

could You maybe send me Your file?

 

[jasonb75]

That means you didn't enter the formula correctly,

<TABLE style="BORDER-BOTTOM-STYLE: groove; BORDER-BOTTOM-COLOR: #00ff00; BORDER-RIGHT-STYLE: groove; BACKGROUND-COLOR: #fffcf9; BORDER-TOP-COLOR: #00ff00; FONT-FAMILY: Arial; BORDER-TOP-STYLE: groove; COLOR: #000000; BORDER-RIGHT-COLOR: #00ff00; FONT-SIZE: 10pt; BORDER-LEFT-STYLE: groove; BORDER-LEFT-COLOR: #00ff00"><TBODY><TR><TD>Spreadsheet Formulas</TD></TR><TR><TD><TABLE style="FONT-FAMILY: Arial; FONT-SIZE: 9pt" border=1 cellSpacing=0 cellPadding=2><TBODY><TR style="BACKGROUND-COLOR: #cacaca; FONT-SIZE: 10pt"><TD>Cell</TD><TD>Formula</TD></TR><TR><TD>B5</TD><TD>{=SUM(IF(--RIGHT(A1:L1,2)=B4,A2:L3))}</TD></TR></TBODY></TABLE></TD></TR><TR><TD>Formula Array:
Produce enclosing { } by entering
formula with CTRL+SHIFT+ENTER!</TD></TR></TBODY></TABLE>

 

[Forestq]

works fine,
thanks a lot for help,

KING REGARDS,
P.