SUMIF is more efficient if there is only one condition to test for.

If you still need multiple values, use

=SUMPRODUCT(--(ISNUMBER(MATCH($L$22:$L$1166,{"1svc","2cdr"},0))) ,--$M$22:$M$
1166)

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"redneck joe"
wrote in message
...

thanks - both worked. Why do you prefer one over the other??


--
redneck joe


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