Text and Numbers sum in a formula
yes
"Sue F" wrote:
So I need to enter the range where the word range is? of say B3:b7?
--
Sue
"bj" wrote:
if it is always a three character lead when there is text
try
=sum(if(isnumber(range),range,value(trim(right(ran ge,len(range)-3)))))
entered as an array function control-shift-enter
"Sue F" wrote:
Does anyone know how to add rows with both text and numbers:
ct/2.5 ct/8 8 at/8 ct/12 total
I want to add the total to equal 38.50
Thanks!
--
Sue
|