SOLVED

Adding Consecutive cells and listing them out

%3CLINGO-SUB%20id%3D%22lingo-sub-1508956%22%20slang%3D%22en-US%22%3EAdding%20Consecutive%20cells%20and%20listing%20them%20out%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1508956%22%20slang%3D%22en-US%22%3E%3CTABLE%20width%3D%22325%22%3E%3CTBODY%3E%3CTR%3E%3CTD%20width%3D%2240px%22%20height%3D%2257px%22%3EList%3C%2FTD%3E%3CTD%20width%3D%22160px%22%20height%3D%2257px%22%3ESum%20of%203%20consecutive%20Nos%3C%2FTD%3E%3CTD%20width%3D%22124px%22%20height%3D%2257px%22%3EThis%20is%20how%20I%20want%20it%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%2240px%22%20height%3D%2230px%22%3E%3CFONT%20color%3D%22%23FF6600%22%3E2%3C%2FFONT%3E%3C%2FTD%3E%3CTD%20width%3D%22160px%22%20height%3D%2230px%22%3E%3CFONT%20color%3D%22%23FF6600%22%3E12%3C%2FFONT%3E%3C%2FTD%3E%3CTD%20width%3D%22124px%22%20height%3D%2230px%22%3E%3CFONT%20color%3D%22%23FF6600%22%3E12%3C%2FFONT%3E%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%2240px%22%20height%3D%2230px%22%3E%3CFONT%20color%3D%22%23FF6600%22%3E3%3C%2FFONT%3E%3C%2FTD%3E%3CTD%20width%3D%22160px%22%20height%3D%2230px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%22124px%22%20height%3D%2230px%22%3E%3CFONT%20color%3D%22%230000FF%22%3E15%3C%2FFONT%3E%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%2240px%22%20height%3D%2230px%22%3E%3CFONT%20color%3D%22%23FF6600%22%3E7%3C%2FFONT%3E%3C%2FTD%3E%3CTD%20width%3D%22160px%22%20height%3D%2230px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%22124px%22%20height%3D%2230px%22%3E%3CFONT%20color%3D%22%23FF00FF%22%3E15%3C%2FFONT%3E%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%2240px%22%20height%3D%2230px%22%3E%3CFONT%20color%3D%22%230000FF%22%3E5%3C%2FFONT%3E%3C%2FTD%3E%3CTD%20width%3D%22160px%22%20height%3D%2230px%22%3E%3CFONT%20color%3D%22%230000FF%22%3E15%3C%2FFONT%3E%3C%2FTD%3E%3CTD%20width%3D%22124px%22%20height%3D%2230px%22%3E%3CFONT%20color%3D%22%23FF0000%22%3E9%3C%2FFONT%3E%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%2240px%22%20height%3D%2230px%22%3E%3CFONT%20color%3D%22%230000FF%22%3E8%3C%2FFONT%3E%3C%2FTD%3E%3CTD%20width%3D%22160px%22%20height%3D%2230px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%22124px%22%20height%3D%2230px%22%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%2240px%22%20height%3D%2230px%22%3E%3CFONT%20color%3D%22%230000FF%22%3E2%3C%2FFONT%3E%3C%2FTD%3E%3CTD%20width%3D%22160px%22%20height%3D%2230px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%22124px%22%20height%3D%2230px%22%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%2240px%22%20height%3D%2230px%22%3E%3CFONT%20color%3D%22%23FF00FF%22%3E2%3C%2FFONT%3E%3C%2FTD%3E%3CTD%20width%3D%22160px%22%20height%3D%2230px%22%3E%3CFONT%20color%3D%22%23FF00FF%22%3E15%3C%2FFONT%3E%3C%2FTD%3E%3CTD%20width%3D%22124px%22%20height%3D%2230px%22%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%2240px%22%20height%3D%2230px%22%3E%3CFONT%20color%3D%22%23FF00FF%22%3E7%3C%2FFONT%3E%3C%2FTD%3E%3CTD%20width%3D%22160px%22%20height%3D%2230px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%22124px%22%20height%3D%2230px%22%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%2240px%22%20height%3D%2230px%22%3E%3CFONT%20color%3D%22%23FF00FF%22%3E6%3C%2FFONT%3E%3C%2FTD%3E%3CTD%20width%3D%22160px%22%20height%3D%2230px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%22124px%22%20height%3D%2230px%22%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%2240px%22%20height%3D%2230px%22%3E%3CFONT%20color%3D%22%23FF0000%22%3E1%3C%2FFONT%3E%3C%2FTD%3E%3CTD%20width%3D%22160px%22%20height%3D%2230px%22%3E%3CFONT%20color%3D%22%23FF0000%22%3E9%3C%2FFONT%3E%3C%2FTD%3E%3CTD%20width%3D%22124px%22%20height%3D%2230px%22%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%2240px%22%20height%3D%2230px%22%3E%3CFONT%20color%3D%22%23FF0000%22%3E3%3C%2FFONT%3E%3C%2FTD%3E%3CTD%20width%3D%22160px%22%20height%3D%2230px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%22124px%22%20height%3D%2230px%22%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%2240px%22%20height%3D%2230px%22%3E%3CFONT%20color%3D%22%23FF0000%22%3E5%3C%2FFONT%3E%3C%2FTD%3E%3CTD%20width%3D%22160px%22%20height%3D%2230px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%22124px%22%20height%3D%2230px%22%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3C%2FTBODY%3E%3C%2FTABLE%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHow%20can%20i%20create%20the%20third%20column%20for%20the%20data%20in%20Column1%20and%20the%20input%203%20(i.e.%203%20consecutive%20numbers..%20i%20want%20to%20add%20them%20up%20in%20this%20case).%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1508956%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1509444%22%20slang%3D%22en-US%22%3ERe%3A%20Adding%20Consecutive%20cells%20and%20listing%20them%20out%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1509444%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F722358%22%20target%3D%22_blank%22%3E%40arvexcel%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThat%20could%20be%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22image.png%22%20style%3D%22width%3A%20843px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F204183i8360AEE261CF341E%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22image.png%22%20alt%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3Eor%3C%2FP%3E%0A%3CPRE%20class%3D%22lia-code-sample%20language-excel%22%3E%3CCODE%3E%3DSUM(INDEX(B%3AB%2C(ROW()-ROW(%24B%243)-1)*3%2BROW(%24B%243)%2B1)%3AINDEX(B%3AB%2C(ROW()-ROW(%24B%243)-1)*3%2BROW(%24B%243)%2B3))%3C%2FCODE%3E%3C%2FPRE%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1509745%22%20slang%3D%22en-US%22%3ERe%3A%20Adding%20Consecutive%20cells%20and%20listing%20them%20out%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1509745%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3E%40Sergei%20Baklan%3C%2FA%3E%26nbsp%3Bur%20a%20genius.%20Thanks%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1509937%22%20slang%3D%22en-US%22%3ERe%3A%20Adding%20Consecutive%20cells%20and%20listing%20them%20out%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1509937%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F722358%22%20target%3D%22_blank%22%3E%40arvexcel%3C%2FA%3E%26nbsp%3B%2C%20you%20are%20welcome%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor
ListSum of 3 consecutive NosThis is how I want it
21212
3 15
7 15
5159
8  
2  
215 
7  
6  
19 
3  
5  

 

How can i create the third column for the data in Column1 and the input 3 (i.e. 3 consecutive numbers.. i want to add them up in this case).

 

Thanks

3 Replies
Best Response confirmed by arvexcel (New Contributor)
Solution

@arvexcel 

That could be

image.png

or

=SUM(INDEX(B:B,(ROW()-ROW($B$3)-1)*3+ROW($B$3)+1):INDEX(B:B,(ROW()-ROW($B$3)-1)*3+ROW($B$3)+3))

@Sergei Baklan ur a genius. Thanks

@arvexcel , you are welcome