Excel Query about cumulative summation in the data table

[Hrishi]

Hello,
I have various rows with data 1,2,3,4,etc and various columns having ascending numbers from left to right. Like this

-- removed inline image ---


Now, at different sheet, if I give reference to the 3 and 20173, I want total of all the data mentioned in row 4 starting from 20171 till 20173. Can you help me ?

Regards
Hrishi

 

[Hrishi]

Hello, I think the Image of table I have pasted is not showing up.

Sr No Date 20171 20172 20173 20174
1 1 5 7 9
2 5 8 6
3 4 5 7
4 3 2 4 8
5 5 5

 

[Hrishi]

[TABLE="class: grid, width: 500, align: left"]
<tbody>[TR]
[TD]Sr No / Date
[/TD]
[TD]20171
[/TD]
[TD]20172
[/TD]
[TD]20173
[/TD]
[TD]20174
[/TD]
[/TR]
[TR]
[TD]1
[/TD]
[TD]5
[/TD]
[TD]6
[/TD]
[TD]8
[/TD]
[TD]7
[/TD]
[/TR]
[TR]
[TD]2
[/TD]
[TD]3
[/TD]
[TD]2
[/TD]
[TD]5
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]3
[/TD]
[TD]1
[/TD]
[TD]2
[/TD]
[TD]8
[/TD]
[TD]7
[/TD]
[/TR]
[TR]
[TD]4
[/TD]
[TD][/TD]
[TD][/TD]
[TD]3
[/TD]
[TD]5
[/TD]
[/TR]
</tbody>[/TABLE]









Data is arranged like above table

 

[FormR]

columns having ascending numbers from left to right.

Hi, welcome to the forum! if I have understood correctly, see if you can adapt this to your actual two sheet set-up.

Excel 2013
	A	B	C	D	E	F	G	H	I
1	Sr No / Date	20171	20172	20173	20174
2	1	5	6	8	7		3	20173	11
3	2	3	2	5
4	3	1	2	8	7
5	4			3	5
Sheet1

Cell Formulas
Range	Formula
I2	=SUMIFS(INDEX($B$2:$E$5,MATCH(G2,$A$2:$A$5,0),0),$B$1:$E$1,"<="&H2)

 

[Hrishi]

Hey Thank you very much for the solution.

 

[Hrishi]

Hi, this formula is working on sample sheet, but not working in my original sheet where I have quite huge date. It is even not showing any error. Is there any way I can share my worksheet with you?

 

[Hrishi]

Its not working in original file. plz guide

 

[FormR]

Its not working in original file. plz guide

Hi, try to describe your exact set-up, sheet names, ranges and cell references for all the various parts.