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