John,
your an absolute legend!!!
I had sumproduct((******),--(*******),--(*********)) and it was only
counting the first range criteria, got this off reading other posts but
could't quite crack it.

Thanks very much
Leo

"John Michl" wrote:

Leo,

=SUMPRODUCT((A2:A5="North")*(B2:B5="PSR")*(C2:C5=" Yes"))

- John
www.JohnMichl.com