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

=SUM(A1:A10) sums numeric values only

Did you use =A1+A2+A3+ ... ?

Cheers,
--
AP


"quailc" a écrit dans
le message de news: ...

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

I have been using the fomula below to sum over a range of data that
includes numbers and words. For some reason it brings back an error
message when I leave the text but the message clears if I delete it.

=(SUMPRODUCT(1*($B$11:$B$28="A&C Cert"),1*(E10="L")*E$11:E$28))*$D$86


I appreciate your advice of using A1:A10 but this is what I have done
and it still comes backs with an error message.

Any suggestions?

Many 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