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