That may be so RD, but firstly the OP never stated this, so it makes me
think that this is not known, which means a potential error is being
overlooked. Secondly, it is summing based upon a condition, which
possibly/probably precludes the *mixed* data. There is a strong possibility
that there are either text lookie numbers there, or so much data that there
is text buried in there. Either way I think the OP should satisfy themselves
that it is okay to ignore that data.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Ragdyer" wrote in message
...
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