Countifs, 2 conditions (dates and text)

Hello readers,

This is a table I have in my “sheet 1”

Update Type Date concept Date test Date 1 Date 2
Small 01/02/2017 15/03/2017 25/09/2017 02/02/2018
Medium 01/02/2017 15/05/2017 25/11/2017 02/05/2018
Large 01/02/2018 15/03/2018 25/05/2019 02/10/2019
Small 15/02/2017 01/09/2017 25/05/2018 02/09/2018

On my “sheet 2”

The User selects the month from a drop down list on “cell A1” and Year on “cell B1”, (no need for day).

“Sheet 2” has a table which should fill automatically.

The table should fill the count based on 2 conditions.
1. Month and year from “sheet 1”
2. Update type from “sheet1”

This is how the table looks like:

Count Count Count Count
Update Type Date concept Date test Date 1 Date 2
Small
Medium
Large

For example:
When user selects 02 & 2017 (Feb 2017) from the drop down list on “sheet 2”.

Table in “Sheet 2” needs to automatically show:

Count Count Count Count
Update Type Date concept Date test Date 1 Date 2
Small 2
Medium 1
Large


Any help would be appreciated.

Triumphexcel

i have created a new thread, i don't know how to delete this thread?