Summing range that contains text

[quailc]

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

 

[Ardus Petus]

=SUM(A1:A10) sums numeric values only

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

Cheers,

 

[quailc]

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