Perhaps it's *mixed* data Bob, which might not necessarily make it *bad*.<g
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Bob Phillips" wrote in message
...
Which means that you have text in a number field as I suggested. If you
want
to ignore bad data, so be it.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"redneck joe"
wrote in message
...

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