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.
<colgroup><col><col span="13"></colgroup><tbody>
</tbody>
<colgroup><col><col span="6"></colgroup><tbody>
</tbody>
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>