COUNTIF Help please with unique filter

Hello all,

I have a unique filter applied

in column R: =UNIQUE(FILTER($I$2:$N$27, $H$2:$H$27 = "Chilled- Microwave Snacking"))

i WANt a countif in cell y6 that counts the number of time the unique combination appears from column I-N

For example.. row 9: =COUNTIFS($I$6:$I$1000, R9, $J$6:$J$1000, S9, $K$6:$K$1000, T9, $L$6:$L$1000, U9, $M$6:$M$1000, V9, $N$6:$N$1000, W9) the result of my countif shows 22, I would expect the result to be 50:

Chl M/W Snk- Burger In Bn Beef Not Applicable Non RTC Chilled Burger in a Bun

the combination above if I filtere these in column I-N shows 50, can anyone help?

thank you so much

So would I, and so it will if you make the ranges long enough:

=COUNTIFS($I$6:$I$56, R6, $J$6:$J$56, S6, $K$6:$K$56, T6, $L$6:$L$56, U6, $M$6:$M$56, V6, $N$6:$N$56, W6)

Marked as solved and, as usual, no feedback. It's common courtesy to acknowledge any help offered to you.

Remember that you can thank anyone who offered you help towards a solution for your issue by clicking the small star icon (* Add Reputation) located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of each of those who offered help.