Filtered Countif / Subtotal?

[CuriousForge]

Target: Blue Cell
Q. I want to filter dates and derive the counts of the Item & Decision as a total. I want the total to change each time the date is filtered. So that's two criteria's based on which a total needs to be derived.
___________________________________________

I am at my wits end with AGGREGATE & cant get my mind to do the SUMPRODUCT(SUBTOTAL etc required for this to work. Silent lurker since a year. It would be immensely helpful if someone could help.

 

[jorismoerings]

Hi,

Try this and see if it helps:

Book1
	A	B	C	D	E
1	Date In	Date Out	Name	Item	Decision
2	18-8-2018	31-10-2018	John	Watch	Approved
4	31-8-2018	31-10-2018	Miranda	iPad	declined
5	12-9-2018	31-10-2018	Joe	Mobile	Approved
6	15-9-2018	31-10-2018	Chris	Mobile	declined
7	17-9-2018	31-10-2018	Shawn	Mobile	declined
8	5-10-2018	31-10-2018	Chloe	iPad	declined
9	21-10-2018	31-10-2018	Kristy	Watch	Approved
10
11		iPad	Watch	Mobile
12	Approved	0	2	1	3
13	Declined	2	0	2	4
Sheet1

Cell Formulas
Range	Formula
B12	=SUMPRODUCT(SUBTOTAL(3,OFFSET($D$2:$D$9,ROW($D$2:$D$9)-MIN(ROW($D$2:$D$9)),,1)),ISNUMBER(SEARCH(B$11,$D$2:$D$9)*SEARCH($A12,$E$2:$E$9))+0)

 

[CuriousForge]

You, sir, are a genius! Thank you, it works! :D