And we have a winner....

thank a million for the help.

j







daddylonglegs Wrote:
You could still use SUMIF....

=SUM(SUMIF($L$22:$L$1166,{"1svc","xyz"},$M$22:$M$1 166))


--
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