Count of particular unique items in a list-Revisited

Last week in the post https://www.excelforum.com/excel-for...in-a-list.html 6StringJazzer posted a great, easy to understand formula that I needed then:

=SUM(IF(LEFT(UNIQUE($D$10:$D$27447),5)="2024_",1,0))l

I'm actually working with a table, so I changed it like so:

=SUM(IF(LEFT(UNIQUE(BudTbl[FY_AP]),5)="2024_",1,0))

Now I've hit the next conundrum, which is a variation on the first. I want to get the count of UNIQUE combinations of "2024_" in the "FY_AP column" (which the first formula does) but only where the Ledger value is "FTE".

I thought it would be a simple AND, like so:

=SUM(IF(AND(LEFT(UNIQUE(BudTbl[FY_AP]),5)="2024_",UNIQUE(BudTbl[Ledger])="FTE"),1,0))

That formula works, in that it doesn't return a zero, but it also doesn't return the proper result. While there are four unique "2024_"'s, only 3 match with FTE, so the proper answer is 3. Any ideas on what I'm doing wrong in my formula?