Excel formula to update values for specific columns only

[vinwin06]

Hello all,

I am looking for an excel formula which would pickup from whole data , here with attached data for your reference. Data available in columns like from Jan to Dec and output i dont want to show everything in one go so only selected months need to be shown in output summary. which formula should i write for it. Here with attaching the sample table. Thanks in advance.

[TABLE="width: 929"]
<colgroup><col><col span="13"></colgroup><tbody>[TR]
[TD]Input[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Business name[/TD]
[TD]Line item[/TD]
[TD]Jan 18[/TD]
[TD]Feb 18[/TD]
[TD]Mar 18[/TD]
[TD]Apr 18[/TD]
[TD]May 18[/TD]
[TD]Jun 18[/TD]
[TD]Jul 18[/TD]
[TD]Aug 18[/TD]
[TD]Sep 18[/TD]
[TD]Oct 18[/TD]
[TD]Nov 18[/TD]
[TD]Dec 18[/TD]
[/TR]
[TR]
[TD]Gas[/TD]
[TD]Sales[/TD]
[TD="align: right"]-1.542[/TD]
[TD="align: right"]3.65E-05[/TD]
[TD="align: right"]-3.7E-05[/TD]
[TD="align: right"]-0.46118[/TD]
[TD="align: right"]-0.00394[/TD]
[TD="align: right"]0.00058[/TD]
[TD="align: right"]-0.65081[/TD]
[TD="align: right"]0.000419[/TD]
[TD="align: right"]0.000405[/TD]
[TD="align: right"]-0.66324[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]-0.0004[/TD]
[/TR]
[TR]
[TD]Vehicle[/TD]
[TD]Sales[/TD]
[TD="align: right"]0.409249[/TD]
[TD="align: right"]0.330625[/TD]
[TD="align: right"]0.508109[/TD]
[TD="align: right"]0.328616[/TD]
[TD="align: right"]1.294699[/TD]
[TD="align: right"]0.34993[/TD]
[TD="align: right"]0.296669[/TD]
[TD="align: right"]0.3237[/TD]
[TD="align: right"]0.317785[/TD]
[TD="align: right"]0.317791[/TD]
[TD="align: right"]0.318828[/TD]
[TD="align: right"]0.868142[/TD]
[/TR]
[TR]
[TD]Gas[/TD]
[TD]Cost[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]-2.2[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]-0.83482[/TD]
[/TR]
[TR]
[TD]Vehicle[/TD]
[TD]Cost[/TD]
[TD="align: right"]-3.69099[/TD]
[TD="align: right"]2.417468[/TD]
[TD="align: right"]7.552902[/TD]
[TD="align: right"]20.91155[/TD]
[TD="align: right"]10.17526[/TD]
[TD="align: right"]-10.2645[/TD]
[TD="align: right"]-22.0394[/TD]
[TD="align: right"]39.16146[/TD]
[TD="align: right"]-119.139[/TD]
[TD="align: right"]-27.3145[/TD]
[TD="align: right"]63.04662[/TD]
[TD="align: right"]-9.97523[/TD]
[/TR]
[TR]
[TD]Gas[/TD]
[TD]NIBIAT[/TD]
[TD="align: right"]31.24384[/TD]
[TD="align: right"]-35.6563[/TD]
[TD="align: right"]-120.603[/TD]
[TD="align: right"]7.633065[/TD]
[TD="align: right"]-80.2893[/TD]
[TD="align: right"]-27.0659[/TD]
[TD="align: right"]16.93894[/TD]
[TD="align: right"]116.006[/TD]
[TD="align: right"]-157.01[/TD]
[TD="align: right"]354.2619[/TD]
[TD="align: right"]2.82761[/TD]
[TD="align: right"]-127.001[/TD]
[/TR]
[TR]
[TD]Vehicle[/TD]
[TD]NIBIAT[/TD]
[TD="align: right"]38.00016[/TD]
[TD="align: right"]-38.142[/TD]
[TD="align: right"]-125.43[/TD]
[TD="align: right"]-8.75795[/TD]
[TD="align: right"]-92.5182[/TD]
[TD="align: right"]-6.83274[/TD]
[TD="align: right"]38.88822[/TD]
[TD="align: right"]79.18886[/TD]
[TD="align: right"]-59.4034[/TD]
[TD="align: right"]379.9576[/TD]
[TD="align: right"]-47.6821[/TD]
[TD="align: right"]-116.335[/TD]
[/TR]
</tbody>[/TABLE]


[TABLE="width: 481"]
<colgroup><col><col span="6"></colgroup><tbody>[TR]
[TD]Output[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Jan 18[/TD]
[TD]Feb 18[/TD]
[TD]Mar 18[/TD]
[TD="colspan: 3"]YTD[/TD]
[/TR]
[TR]
[TD][/TD]
[TD="colspan: 3"]Month[/TD]
[TD]Actual[/TD]
[TD]LE[/TD]
[TD]Plan[/TD]
[/TR]
[TR]
[TD]Gas[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Vehicle[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[DanteAmor]

You can play a little with a pivot table and check if the result is what you need.

 

[Peter_SSs]

You could also try this formula, copied across and down.

Excel Workbook
	A	B	C	D	E	F	G	H	I	J	K	L	M	N
1	Business name	Line item	Jan-18	Feb-18	Mar-18	Apr-18	May-18	Jun-18	Jul-18	Aug-18	Sep-18	Oct-18	Nov-18	Dec-18
2	Gas	Sales	-1.542	3.65E-05	-3.70E-05	-0.46118	-0.00394	0.00058	-0.65081	0.000419	0.000405	-0.66324	0	-0.0004
3	Vehicle	Sales	0.409249	0.330625	0.508109	0.328616	1.294699	0.34993	0.296669	0.3237	0.317785	0.317791	0.318828	0.868142
4	Gas	Cost	0	0	0	0	0	0	0	-2.2	0	0	0	-0.83482
5	Vehicle	Cost	-3.69099	2.417468	7.552902	20.91155	10.17526	-10.2645	-22.0394	39.16146	-119.139	-27.3145	63.04662	-9.97523
6	Gas	NIBIAT	31.24384	-35.6563	-120.603	7.633065	-80.2893	-27.0659	16.93894	116.006	-157.01	354.2619	2.82761	-127.001
7	Vehicle	NIBIAT	38.00016	-38.142	-125.43	-8.75795	-92.5182	-6.83274	38.88822	79.18886	-59.4034	379.9576	-47.6821	-116.335
8
9
10		Jan-18	Feb-18	Mar-18
11		Month
12	Gas	29.70184	-35.6562635	-120.603037
13	Vehicle	34.718419	-35.393907	-117.368989
Extract