THANKS!
"Peo Sjoblom" wrote:
In your example the numbers are single digits, if that's the case
=SUMPRODUCT(--(LEFT(A1:A3,1)))
--
Regards,
Peo Sjoblom
"Arturo" wrote in message
...
A1 = 1 X
A2 = 2 X
A3 = 3 X
A4 = 6
Is there some sum left formula that will allow me to total the numbers in
cells A1:A3 and omit the text to the right?
Thank you,
Arturo
|