Help to Make Summary Sheet with Specific Conditions

[global5665]

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.....

 

[oldbrewer]

show us 5 rows of RCU MIS sheet please

 

[global5665]

show us 5 rows of RCU MIS sheet please

Hi,

Send me your email id....I'll share the sheet.

 

[NoSparks]

Send me your email id....I'll share the sheet.

why not just add links to your cross posts ?

 

[oldbrewer]

No no no no no no no no no no no

read the forum rules