Construct a summary sheet by summing up from one or more than one sheet.

**PRADEEPB270** · 11-03-2011, 05:11 AM

I have a file,contains 12 sheets ( Month wise ) and each sheet have approx. 400000 rows.Now,I want to make a summary sheets by given some input datas and expect the required datas from the sheets.
For an example,if ,I want to give the input as plant-HHHD and Month-Oct,2011,then, represent the Oct'2011 datas and plant HHHD only.Sometimes,it is to be happen,that, plant may be HHHD and HHHG and month may be Oct,Nov and Dec.In that case, the summary sheet should be shown as the sum of both of plants and also the sum of months.
Is it possible through an excel formula?

For more clarification,please refer the attached file.
(Pl.to be note that each sheet of attached file size has reduced )

If it is possible,put the excel formula on attached file.

Regards

Pradeep Kumar Gupta

**arlu1201** · 11-03-2011, 05:31 AM

A combination of Indirect, Index and Match can assist you easily so that if you either enter the key or select from the dropdown, the data will automatically populate.
However, when it comes to multiple options, it will get very complicated. Will it possible to have the options like HHHD / HHHG or even the months in separate cells? That way, we can use a sum as well along with the Indirect, index and match.

**PRADEEPB270** · 11-04-2011, 02:26 AM

Originally Posted by arlu1201

a combination of indirect, index and match can assist you easily so that if you either enter the key or select from the dropdown, the data will automatically populate.
However, when it comes to multiple options, it will get very complicated. Will it possible to have the options like hhhd / hhhg or even the months in separate cells? That way, we can use a sum as well along with the indirect, index and match.

is it not possible to any other excel formula or pivot table etc.?