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.

Input
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
Gas	Sales	-1.542	3.65E-05	-3.7E-05	-0.46118	-0.00394	0.00058	-0.65081	0.000419	0.000405	-0.66324	0	-0.0004
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
Gas	Cost	0	0	0	0	0	0	0	-2.2	0	0	0	-0.83482
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
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
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

<colgroup><col><col span="13"></colgroup><tbody>
</tbody>

Output
	Jan 18	Feb 18	Mar 18	YTD
	Month	Actual	LE	Plan
Gas
Vehicle

<colgroup><col><col span="6"></colgroup><tbody>
</tbody>

 

[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