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,
--
AP


"quailc" <[email protected]> a écrit dans
le message de news: [email protected]...
>
> 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
>

[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