Counting filtered with size parameter

[Pete sheets]

Hi All.

Hoping you could help with the below.
I need to be able to filter to a department manager and then the highlighted boxes tell me the number of departments that are up on last year and down on last year. Countif is fine until you filter by the department manager and then it doesn't change. Aggregate is my usual go to but I don't know how to set it up with the % up or down parameter.

 

[Fluff]

Hi & welcome to MrExcel.
How about

=ROWS(FILTER(C4:C10,(C4:C10>0)*(MAP(C4:C10,LAMBDA(m,SUBTOTAL(3,m))))))

 

[Pete sheets]

Hi & welcome to MrExcel.
How about

=ROWS(FILTER(C4:C10,(C4:C10>0)*(MAP(C4:C10,LAMBDA(m,SUBTOTAL(3,m))))))

Absolutely perfect. I had no chance of getting that. Appreciate it.

 

[Fluff]

You're welcome & thanks for the feedback.