Question about Microsoft Excel 2000 Step by Step (1572319747) for PC
I'm looking for a formula that will allow me to calculate the total of the lowest two cells from any 3 cells in a row
For example if your numbers are in cells A1, B1 and C1
=MIN(A1:C1)+MEDIAN(A1:C1)
only works for 3 numbers as you requested.
Posted on Nov 07, 2008
Hi,
a 6ya expert can help you resolve that issue over the phone in a minute or two.
best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.
the service is completely free and covers almost anything you can think of (from cars to computers, handyman, and even drones).
click here to download the app (for users in the US for now) and get all the help you need.
goodluck!
Posted on Jan 02, 2017
Jan 19, 2016 | Computers & Internet
Apr 09, 2014 | Microsoft Excel for PC
Sep 30, 2009 | Microsoft Excel for PC
Sep 27, 2009 | Microsoft Excel for PC
Apr 18, 2009 | Microsoft Office Excel 2003 for PC
Sep 02, 2008 | Microsoft Excel for PC
Jul 29, 2008 | Microsoft Excel for PC
Apr 09, 2008 | Microsoft Excel for PC
Dear Madiha35,
I would recommend the use of the Table Function in Excel.
Here are the steps in Excel 2007, if this does not work for your version please add comment for me to reply to.
Conversely, If you would like the softcopy of the screenshots, I would be happy to email them to you.
Step 1: Enter your data into the worksheet.
Step 2: Create Table
Highlight the relevant data
On the insert tab, click on Table
Step 3: Verify Table range is correct, Click OK
Step 4: Select the cell you where you wish to Sum Data.
Click on Autosum.
Step 5: To Insert new data
Click on the sum row in the table, (Not the entire worksheet row)
Right click, Insert, Insert Table rows from above
Step 6: Enter new data in row
Step 7: Data is automatically calculated in formula.
Oct 22, 2007 | Computers & Internet
Oct 22, 2007 | Microsoft Excel 2003 (06503995)
Apr 07, 2010 | Microsoft Excel 2000 Step by Step...
141 people viewed this question
Usually answered in minutes!
×