countifs, 2 conditions, dates and text match.

[exceltriumph]

Hello readers,

I have attached a excel file with data on Sheet 1 and Sheet 2.

“sheet 1” has a table.

"sheet 2” has the option for user to interact by selecting 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 based on the value on cell A1 & B1.

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

"Sheet 2" also shows an example of how the table would like like when Feb(02) and Year (2017 is selected on cells A1 & B1.

Any help would be appreciated.

Triumphexcel

[Richard Buttrey]

Personally I'd use a Pivot Table which avoids functions altogether and gives you a lot more functionality for other reporting needs you may have.

See attached where I've added a helper column to your data and used that for a Slicer filter with the PT.

[exceltriumph]

thanks for Pivot table advise,

unfortunately i cannot use pivot table as the user will replace certain cells.

is there a way to achieve via formulas?

Cheers