countifs named range gives #VALUE error

I just replaced the values within a formula and now it's value errors all the way, I'm not sure why:

old formula: =COUNTIFS(Cat,M$3,Sup,$B45)

new formula: =COUNTIFS(Cat,M$3,Client,$B45)

simply doing =COUNTIFS(Cat,M$3) and =COUNTIFS(Client,$B45) works, but I obviously need the common count of the two!

=SUMPRODUCT(COUNTIFS(Cat,M$3,Client,$B45)) also gives #value error

The named ranges work, so what is the problem?