Why not =SUM(A1:J1) since SUM ignores text?
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"HappyTrucker"
wrote in message
news:HappyTrucker.1tr3uc_1124017510.4987@excelforu m-nospam.com...

Hi,

I have a row of cells. as below:

Hol 8.00 9.75 9.00 Hol 8.00 10 9.25 9.00 8.25

I want to add the numerical elements in this row, but the text parts
are causing an error. Is there a forumula that will only add the
numerical parts, without resorting to nested IF statements saying
IF(cell="Hol") etc etc?

Thanks in advance


--
HappyTrucker
------------------------------------------------------------------------
HappyTrucker's Profile:
http://www.excelforum.com/member.php...o&userid=25997
View this thread: http://www.excelforum.com/showthread...hreadid=395644