# Re: [libreoffice-users] Re: sum text column of common unit of measure numbers

Hello,
I just realised I messed up since I did not think about the
units.Considering:
1 GB = 1024 MB1 MB = 1024 KB
you can change the formula like this:
=SUM(IFERROR(VALUE(SUBSTITUTE(A2:A29,"
KB","")),0),IFERROR(VALUE(SUBSTITUE(A2:A29,"
MB",""));0)*1024,IFERROR(VALUE(SUBSTITUE(A2:A29,"
GB",""));0)*1024*1024)
This will give you the number of KB transferred. If you want the total
in MB, just divide the SUM by 1024.
I hope this helps,
Rémy.

Le jeudi 07 mai 2020 à 17:09 -0500, Wade Smart a écrit :
> =IF(B1="kb",A3, IF(B1="mb",A1*1000,A1*1000000))
>
> -- Registered Linux User: #480675Registered Linux Machine:
> #408606Linux since June 2005
> On Thu, May 7, 2020 at 4:56 PM Wade Smart <wadesmart@gmail.com>
> wrote:
> > =if(B1="MB,A1*1000,A1*??)
> > You just change the final A1 to multiple by another number.
> > --Registered Linux User: #480675Registered Linux Machine:
> > #408606Linux since June 2005
> > On Thu, May 7, 2020 at 4:46 PM James <bjlockie@lockie.ca> wrote:
> > > On 2020-05-07 4:17 p.m., Malcolm Jaros wrote:
> > > > In Cell C1 put =IF(B1="MB",A1*1000,A1)
> > > How can I have 2 IFs in case there are GBs?
> > >
> > > --To unsubscribe e-mail to:
> > > users+unsubscribe@global.libreoffice.org
> > > Problems?
> > > https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
> > > Posting guidelines + more:
> > > https://wiki.documentfoundation.org/Netiquette
> > > List archive: https://listarchives.libreoffice.org/global/users/