Creating dashboard to show stats based on 5 different dates range and criteria

[Sakshi]

I have 5 different dates such as deal open date, deal close date, deal announce date, deal signed date, deal completion date along with 60000 rows of data and it will keep increasing

each date has different range of cells in different worksheet.
I have derived year, month and quarter from each set of date and based on the value selected in dropdowns of year, month and quarter of each date I have to provide stats...

Countifs has some limitations, however, I have n number of conditions on which basis I have to show stats...
for e.g someone just want to see how many deals were completed on basis of deal date open
but other person want to see how many deals were completed on basis of deal date completed or announced
and 3rd person want to see how many deals were opened (on basis of deal date open) in specific year , quarter or month and out of them how many deals were closed (on basis of deal date completed or announced) in specific year , quarter or month.

I have tried nested if with countifs but formula became too long and messy...

Can you tell me easiest way to do this without vba and macro???

 

[NARAYANK991]

Hi ,

The easiest way is for you to upload your workbook with the data in it , and give all of the statistics that will be required , along with the logic of how they can be derived using the data.

Narayan