Trying Sumproduct with multiple criteria 1) greater than, or 2) partial text

Originally Posted by Groovicles

Hi Tony,

Total count should be 5.

OK, so you want to count a ROW if any cell on that row meets the condition.

Try this...

=SUMPRODUCT(SIGN((A1:A6>625)+(LEFT(B1:B6,2)="CA")+(LEFT(C1:C6,2)="CA")))