Countifs & Isnumber combo

[BrutalLogiC]

Hello,

I am trying to use ISNUMBER in a countifs formula and it's not working so appreciate if someone can help me out. It doesn't return an error but it's not counting the numeric values in column AM.

I had this formula:
=COUNTIFS(Master!$L:$L,Inhouse!$B5,Master!$AK:$AK,"yes",Master!$E:$E,"corporate")

but also wanted to count the number of numeric values in column AM so tried changing it to below which is not counting the values, it's returning 0.

=COUNTIFS(Master!$L:$L,Inhouse!$B5,Master!$AK:$AK,"yes",Master!$E:$E,"corporate",Master!AM:AM,isnumber=TRUE)

I hope above is enough information for someone to help me

thanks very much

 

[Fluff]

You cannot do that with countifs, you need to use sumproduct instead

=SUMPRODUCT((Master!$L$2:$L$1000=$B5)*(Master!$AK$2:$AK$1000="yes")*(Master!$E$2:$E$1000="corporate")*(ISNUMBER(Master!$AM$2:$AM$1000)))