Hi all,

I'm doing a clean up of some shared drives and am trying to quantify the
amount of disk space save.
Some files are small and only 200 KB, others are 300 MB and some folders are
even in GB. Is there a way that excel can count KB/MB/GB and convert into one
GB sum?

I'd appreciate any help.

thanks,

Chris

to convert kb to mb, divide by 1024, to convert mb to gb, divide by 1024
How is the size data entered in excel, if the number is in one column and
the GB/KB/MB in another, you can use IF statements to see what you have to
divide by, or multiply by. If it's all in one cell, you can use LEFT and
RIGHT statements to seperate the number from the rest.

"Chrischik" wrote:

Hi all,

I'm doing a clean up of some shared drives and am trying to quantify the
amount of disk space save.
Some files are small and only 200 KB, others are 300 MB and some folders are
even in GB. Is there a way that excel can count KB/MB/GB and convert into one
GB sum?

I'd appreciate any help.

thanks,

Chris

Are your values in bytes or kb or mb or gb?

If the values are in bytes, you can sum all of them and divide by:

1024 to get kb
1024*1024 to get mb
1024*1024*1024 to get gb

This is not the marketing formula. They use 1000 instead. So it sounds like
harddrives have more space than they really do.



Chrischik wrote:

Hi all,

I'm doing a clean up of some shared drives and am trying to quantify the
amount of disk space save.
Some files are small and only 200 KB, others are 300 MB and some folders are
even in GB. Is there a way that excel can count KB/MB/GB and convert into one
GB sum?

I'd appreciate any help.

thanks,

Chris

--

Dave Peterson

Hi Chris,

Yes, Excel can definitely help you with this task. Here's how you can convert KB to MB and GB and then sum them up in GB:

1. First, create a new column in Excel where you will enter the file sizes in KB.
   
2. Next, create two new columns for MB and GB. In the MB column, enter the formula
   Formula:

   "=A1/1024" 

   (assuming your KB values are in column A). This will convert the KB values to MB. In the GB column, enter the formula
   Formula:

   "=B1/1024" 

   (assuming your MB values are in column B). This will convert the MB values to GB.
   
3. Now, you can sum up the GB column to get the total amount of disk space saved. To do this, simply use the SUM function and select the range of cells in the GB column that you want to add up. The result will be in GB.
   

For example, if your KB values are in column A and you have converted them to GB in column C, you can use the formula to add up the total amount of disk space saved in GB.