No, SP just does the summing in this case, the -- coerces the text value to
a number.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Bugjam1999" wrote
in message ...

Now we're cooking with gas :)

that works fine... thank you very much :)

just for interests sake - sum product asks excel to make a number out
of a text cell? and the relevance of the two dashes -- and double
brackets?

thanks guys, much appreciated...

S.


--
Bugjam1999
------------------------------------------------------------------------
Bugjam1999's Profile:
http://www.excelforum.com/member.php...o&userid=26178
View this thread: http://www.excelforum.com/showthread...hreadid=394908