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

 

[jasonb75]

You mean like

Excel Workbook
	A	B	C	D	E	F	G	H	I	J	K	L
1	M06	Sum	9
2	M01	M02	M03	M04	M05	M06	M07	M08	M09	M10	M11	M12
3	2	7	4	7	4	3	6	6	1	23	0	6
4	6	6	45	4	78	6	6	0	0	0	6	0
Sheet

Your example is not very clear.

 

[Forestq]

A B C D E F G H I J K L M
1 M01 M02 M03 M04 M05 M06 M07 M08 M09 M10 M11 M12 SUM
2 2 7 4 7 4 3 6 6 1 23 0 6 _____
3 6 6 45 4 78 6 6 0 0 0 6 0 _____

4 current
month
5 6


I can`t install now this soft. maybe, I add print screen.

 

[jasonb75]

My reply didn't show the formula for some reason.

Excel Workbook
	A	B	C	D	E	F	G	H	I	J	K	L
1	M01	M02	M03	M04	M05	M06	M07	M08	M09	M10	M11	M12
2	2	7	4	7	4	3	6	6	1	23	0	6
3	6	6	45	4	78	6	6	0	0	0	6	0
4	Current month	M06
5	Sum	9
Sheet

 

[Forestq]

I can`t instatll this program, there is other possibility to add printscreen or add file with example?

 

[Forestq]

jasonb75,

data loks like my sub., but in current month I have just number like 6 (not M06).

So formula should be this some?

Do You know maybe how to use SUM OffSet in this sub.?

 

[jasonb75]

Then maybe

Excel Workbook
	A	B	C	D	E	F	G	H	I	J	K	L
1	M01	M02	M03	M04	M05	M06	M07	M08	M09	M10	M11	M12
2	2	7	4	7	4	3	6	6	1	23	0	6
3	6	6	45	4	78	6	6	0	0	0	6	0
4	Current month	6
5	Sum	9
Sheet

 

[Forestq]

I don`t know why my result is "0"

 

[jasonb75]

is your data in exactly the same cells?

 

[Forestq]

yes,
I created the new one (workbook,worksheet) to check Your formula and the result show me 0.