Summing range that contains text

Q

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
 
Q

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
 
Top