Count Filtered table with another criteria

[ddander54]

I have an Excel Table (Excel 2016) that I use this array formula to count the number of filtered rows of unique values.

=SUM(IF(FREQUENCY(IF(SUBTOTAL(3,OFFSET(A29,ROW(A29:A11459)-ROW(A29),0)),A29:A11459),A29:A11459),1))-1

So it counts the unique numbers in Col A with each filter.

What I need to do is modify it so that it counts the unique numbers in Col A for specific criteria from Col E (ie, "Billable", "Expense", "Capital").

For instance If I filter on Billable, then Billable = ###, Expense = 0, Capital = 0 and if I filter on Billable and Capital, then Billable = ###, Expense = 0 and Capital = ###

Thanks in advance,
Don

 

[Domenic]

For a unique count of values from Column A, where the corresponding values in Column E equals "Billable", and where the data has been filtered, try...

=SUM(IF(FREQUENCY(IF(SUBTOTAL(3,OFFSET(A29,ROW(A29:A11459)-ROW(A29),0)),IF(E29:E11459="Billable",A29:A11459)),A29:A11459),1))-1

...confirmed with CONTROL+SHIFT+ENTER.

Hope this helps!

 

[ddander54]

Thank you Domenic! It works perfectly!