how do i use lbs and ounces in excel

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Can someone tell me how to use i.e. sum for pounds and ounces.
Also how you could remove two minimum figures from a list.

I would like to use Excel for this.

Regards
Greg
 
at some point, you would have to convert your answer to pounds, do the sum
and convert back to pounds and ounces. Or put in a formula that adds the
ounces, extracts any whole pounds, and adds those to the sum of the pounds.
If is unclear how your data is stored and what you are adding.

You can use the Small function to determine the two lowest value from a sum
with something like

=sum(A1:A10)-Small(A1:A10,1)-Small(A1:A10,2)

or

=sum(A1:A10)-Sum(small(A1:A10,{1,2}))
 
Hi Tom

That answers my questions perfectly.
Thanks very much for your help.

Regards
Greg Phillips
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Convert ounces to grams via dropdown list in Excel 2
lbs ounces grams 6
Lbs and Ounces 1
adding pounds and ounces 8
Calculate weight (ounces into pounds) in Excell? 4
Where can i find abbreviations for use in excel formulas 3
How do i format a number into stones, pounds and ounces, please? 5
Convert Grams to Ounces, Ounces to Grams without a conflict 5

Back
Top