Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

Hello, I have 3 cells each one of the cells receives certain amount of numbers in MB, GB, and TB. I want to create another cell to sum all the entries in these cells as a total and give the answer in TB. I appreciate your help.

The sum will be in A4 and the formula will be: =A1/1000000+A2/1000+A3

that will be corrent since 1TB = 1000000 MB, and 1TB = 1000GB.

Hote that helps'

Zvitam.

Screen-Shot-2018-03-13-at-11.39.09.png

You cannot sum those values because they are not numbers - they contain text.

Attach the workbook and I'll amen it so that the sum will work.

I uploaded the workbook.

Book1.xlsx

Book1.xlsx

There are some solutions to adding mixed kb mb & gb values here

This article might help you understand

Book1--4-.xlsx

1MB = 1024KB,

1GB = 1024MB,

1TB = 1024GB

However, the publicly recognised factoring is 1000

Following

The sum will be in A4 and the formula will be: =A1/1048576+A2/1024+A3

that will be corrent since 1TB = 1048576 MB, and 1TB =1024GB.

=SUM(LEFT(C3,SEARCH("B",C3

=SUM(VALUE(LEFT(C3:G3&"0 TB",FIND("B",C3:G3&"0 TB")-2))/CHOOSE(INT((CODE(

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.

=SUM(LEFT(C3,FIND(" ",C3))/1048576,LEFT(D3,FIN

This assumes there will be a space between the value and the letters. If not we could allow for that and tell the find to look for the B instead.

=SUM(LEFT(C3,SEARCH("B",C3

SEARCH is not case sensitive so will look for B and b. Technically Mb is megabits rather than megabytes but I don't believe that is an issue in this scenario.

With sample, expand the result to 3 decimal places and you get 3.029

You can add custom formatting as per Roy's suggestion so that it shows as 3.029 TB but can still be used as a number.