How can I sum a range of data that contains text in some of the columns?
I only want to sum the numerical values.

At the moment, I keep getting the #value error message.

Thanks Corinne


--
quailc
------------------------------------------------------------------------
quailc's Profile: http://www.excelforum.com/member.php...o&userid=34442
View this thread: http://www.excelforum.com/showthread...hreadid=542850