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,