Help to Make Summary Sheet with Specific Conditions

global5665

New Member
Joined
Apr 2, 2017
Messages
2
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.....
 

Excel Facts

What does custom number format of ;;; mean?
Three semi-colons will hide the value in the cell. Although most people use white font instead.

Forum statistics

Threads
1,223,099
Messages
6,170,107
Members
452,302
Latest member
TaMere

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top