COUNTIFS, LEN (and SUMPRODUCT?)

[horizonflame]

Hi All,

I'm looking to do a countifs formula with one of the criteria being a cell length of 9. I've done some research and found the following:

=SUMPRODUCT(--(LEN(C2:C1000)=9))

Can you help with how I can combine this with my countifs:

=COUNTIFS(A2:A1000,"DEFINED",Range2,Criteria2

Many thanks

 

[JoeMo]

Do you want something like this?

=SUMPRODUCT((LEN(C2:C1000)=9)*(A2:A1000="DEFINED"))