COUNTIFS, LEN (and SUMPRODUCT?)

horizonflame

Board Regular
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 :)
 
Last edited:

Some videos you may like

This Week's Hot Topics

Top