Hi,
If your values takes up, for instance the range A2 to A29, you can
enter this formula as an array formula:
=SUM(VALUE(SUBSTITUTE(SUBSTITUTE(A2:A29," KB","")," MB","")))
The only trick is to hit CTRL-SHIFT-ENTER instead of just ENTER at the
end of the formula entry: if you only use ENTER, this
Copy your data into a txt file. Open with your
spreadsheet, separate by space to put numbers
in Col A and Kb/mb in Col b. Col c = A1*1000 to get
total kb. The sum up the whole thing. Divide the total
by 1000 to get mb.
--
Registered Linux User: #480675
Registered Linux Machine: #408606
Linux
Correction
Last line should read
Save as *.ods file
Regards, MalJaros
- Original Message -
From: "maljaros"
To: "Global Users@"
Sent: Thursday, 7 May, 2020 22:00:43
Subject: Fwd: [libreoffice-users] sum text column of common unit of measure
numbers
Hi James
>
Hi James
>My cell phone provider only provides me a CSV with a text field for the
>usage.
>I want to =sum( it so I need it to be numbers.
>Is a macro the easiest way to make a new column of common unit of
>measure (GB?) numbers?
>
>15 KB
>5 KB
>10 KB
>15 KB
>5 KB
>5 KB
>5 KB
>1.8 MB
>5 KB
>5 KB
My cell phone provider only provides me a CSV with a text field for the
usage.
I want to =sum( it so I need it to be numbers.
Is a macro the easiest way to make a new column of common unit of
measure (GB?) numbers?
15 KB
5 KB
10 KB
15 KB
5 KB
5 KB
5 KB
1.8 MB
5 KB
5 KB
15 KB
215 KB
130.2 MB