Countif, non blank values (ID based)

I'm convinced there's a simple solution to the following

I'm looking to count all the non-blank values in KU, but the count resets after the ID (KR) changes.

However, instead of counting, I define a value (KX1), & an IF statement tells me if there were (x, or more i.e. 2 or more in the example fo the spreadsheet) non-blank values of a specific ID

Thanks

Mdn

Try this:

KX2 =COUNTIF(KR:KR,KW2)-COUNTIFS(KR:KR,KW2,KU:KU,"")>=KX1

Brilliant, ty Falcon

You're welcome. Thanks for the rep!