Making summary sheet with specific condition

Hi Friends,

I have an excel workbook consisting two sheet ( RCU MIS and Summary Sheet), in summary sheet i want data in five category as mentioned in the attached sheet.

Summary Sheet description:

There are five particulars in summary sheet, and i want data accordingly from RCU MIS Sheet.

Particular:

1. Date (C2) - I want data here as per data from RCU MIS, let's say if i select 03-03-2017 then No. and Value should be populated as per RCU MIS data.
2. MTD Sum (E2) - Here MTD stands for Month till date, if i select date in cell Q1 and Q2 than i want sum of Total No. and Value during these period from the RCU MIS Sheet.
3. MTD Avg (G2) - As mentioned above here i want Average of No. and Value instead of sum from the RCU MIS sheet.
4. YTD Sum (I2) - Here YTD stands for Year till date, here if i select drop down from Cell T1 and T2 than i want sum of total No. and value during these period from the RCU MIS sheet.
5. YTD Avg (K2) - Same here, i want average of No. and Value instead of sum from the RCU MIS Sheet.

Guys please help me solve this issues ASAP.

Thanks.....

Hi,

The MTD can be done with SUMIFS and AVERAGEIFS. The same with YTD (with assist from helper cells and VLOOKUP)

Attached is a version of your file with the formulas.

Hope this works for you.

Cheers

Thank you so much dear....

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.