How to count rows based on cell value?

Hello everyone, I have a formula in column "I"

Please Login or Register  to view this content.

that works but now I need to make changes to it.

I want the same idea applied except if the value on column "H" is not CBA, then count up to the value in M4. If the value = CBA then count up to the value in M6. I did try on column "J"

Please Login or Register  to view this content.

but that did not return what I want (see column K for what formula should return). Any ideas on other ways I can approach or fix this?

Try this:

=IF(AND(H2="ABC",COUNTIF(H$2:H2,H2)>$M$4),"",IF(AND(H2="CBA",COUNTIF(H$2:H2,H2)>$M$6),"",COUNTIF(H$2:H2,H2)))

I knew I'd overcomplicated it... a bit!!!!

=IFERROR(1/(1/(IF(H2="ABC",IF(COUNTIF(H$2:H2,"ABC")>$M$4,"",COUNTIF(H$2:H2,"ABC")),0)+IF(H2="CBA",IF(COUNTIF(H$2:H2,"CBA")>$M$6,0,COUNTIF(H$2:H2,"CBA")),0))),"")

RoFLAO....

It's usually the other way round - Glenn cuts to the change whilst I'm flapping around trying to get to the crux of the matter!!!

Another one at L2

=IFERROR(--TEXT(COUNTIFS(H$2:H2,H2),"[<="&IF(H2="ABC",M$4,M$6)&"]0;"),"")