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
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
In your example the numbers are single digits, if that's the case
=SUMPRODUCT(--(LEFT(A1:A3,1)))
--
Regards,
Peo Sjoblom
"Arturo" <[email protected]> wrote in message
news:[email protected]...
> 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
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" <[email protected]> wrote in message
> news:[email protected]...
> > 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
>
>
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks