Sum Weights Using Grams

Converting LBS To Grams

Jul 20, 2014

I have an excel workbook that has a column called Weight in LBS. I already have about 7000 products all shown in pounds. Im switching to a new program that requires the weight be shown in grams! Is there any way of converting all of my existing rows to show as grams? They are all different weights, some less than a pound all the way up to 20 pounds!

View 7 Replies View Related

Convert Grams To Lbs,ozs And Drams

Aug 15, 2009

Need formula that would convert grams to lbs,ozs and drams. I know that grams to drams is *0.564383391193 then divide by 256 to lbs but don't know now how to deal with the non full numbers

View 9 Replies View Related

Sumifs Formula To Add Up Weights Between A Defined Period?

Dec 11, 2013

I'm exporting data from an access database into an Excel document and want to use the Sumifs formula to add up weights between a defined period (we have to show tonnages on a weekly basis).

The data and calculations are on a separate worksheets. The data looks like this:

[URL]

I'm trying to sum the data in column E based on the date range in column A and my formula is

=SUMIFS('Site CR'!E$5:E$5000,'Site CR'!A$5:A$5000,">01/11/2013",'Site CR'!A$5:A$5000,A5)

For some reason, my formula always returns 0 and I can't see why.

[URL]

View 4 Replies View Related

Multi-function Formula (=IF) (for Specific Shipping Weights)

Feb 3, 2010

I would like to write a formula for shipping cost in Excel 2003, for specific shipping weights. Each product is a different weight. The result is in a new column.

What formula would I use for this column? The figures below are hypothetical.

A1 is 4 lbs. Shipping is $6.00
A2 is 8 lbs. Shipping is $12.90
A3 is 10 lbs. Shipping is $16.00
A4 is 15 lbs. Shipping is $24.00

Formula for the column is ?

If A1 is greater than 1 lb. and less than 5 lbs. then shipping cost is $6.00 or
A1 is greater than 7 lbs. and less than 10 lbs. then shipping cost is 12.90 or
A1 is greater than 9 lbs. and less than 15 lbs.then shipping cost is $16.00
A1 is greater than 14 lbs. and less than 18 lbs. then shipping cost is $24.50

View 4 Replies View Related