It looks like a viable formula to me - what result do you get?

The curly braces are superfluous here and I'd advise a different
syntax

=SUMPRODUCT(--($L$22:$L$1166="1svc"),$M$22:$M$1166)


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=535222