Countif not working when data filtered

[SSCOB]

Hi, I have a countif formula, and when I filter the data the countif counts don't update. But I would like it to. What do I need to do to show the counts when I filter the data please?

I've *think* I've attached the mini sheet, but added image too.

The data is on the left, and the countif formula is: =COUNTIF(Sheet1!E:I,Sheet1!K2) - which counts all of the data to the left, but I then also want to show that data filtered on 'Type' (highlighted yellow), in the subsequent columns. Is this possible please?

example.xlsx
	F
5	8
Sheet1

 

[alansidman]

The mini sheet only shows one cell. You need to highlight the entire range before copying into xl2bb.

 

[Fluff]

How about

=LET(a,TOCOL(FILTER($E$2:$I$1000,MAP($D$2:$D$1000,LAMBDA(m,SUBTOTAL(3,m))))),IFERROR(ROWS(FILTER(a,a=K2)),0))