It is odd that that one should work and the previous one didn't, they are
the same, the comparison string and the operator apart.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"bruch04" wrote in message
oups.com...
AHA! Okay, I got it to work. I ended up using this formula:

=sumproduct((Left($A$1:$A$7,10)="Monitoring")*$A2: $F7<""))

I gave up on the colour formatting after reading your sumproduct page.
Thanks very much for your help.

Kind regards,