Question about Microsoft Business & Productivity Software

1 Answer

Excel Addition How to add on Excel?

Posted by on

  • dr_ifoley Nov 22, 2008

    Have asked for assistance since I don't know how to use Excel and just wish to add a total

×

1 Answer

  • Level 1:

    An expert who has achieved level 1.

    Hot-Shot:

    An expert who has answered 20 questions.

    Corporal:

    An expert that hasĀ over 10 points.

    Mayor:

    An expert whose answer gotĀ voted for 2 times.

  • Contributor
  • 45 Answers

You may add typed-in values (numbers only) or numbers found in cells.
always start your equation with = then separate values with +

Posted on Nov 25, 2008

Add Your Answer

Uploading: 0%

my-video-file.mp4

Complete. Click "Add" to insert your video. Add

×

Loading...
Loading...

Related Questions:

3 Answers

How do i recover my corrupted MS Excel File ....???


Using proper locations to keep your office documents and making regular backups are great preventive measures against data loss. If you've lost a document or the whole bunch of them, do not despair. Modern data recovery tools can reliably detect, locate and restore documents even if they are stored on a badly damaged, corrupted, formatted or repartitioned hard drive or other storage media.

Use Hetman Office Recovery for recovering your corrupted MS Excel file: https://hetmanrecovery.com/recover_deleted_document/office-software.htm

Oct 17, 2016 | Business & Productivity Software

5 Answers

How to repair damage excel file


Use Excel Repair Toolbox designed to restore data from corrupted .XLS files. MS Office .XLS file repair software can fix many error.
For more: https://www.xlsrepairtoolbox.com/

Jul 14, 2015 | Microsoft Excel for PC

2 Answers

What did I do, excel is frozen, can not scroll up?


It might be as simple as Frozen Panes.
Go Window / Unfreeze Panes and see whether that fixes your problem for you.

Apr 26, 2014 | Microsoft Excel for PC

2 Answers

What are the formulas in grading the grades uisng microsoft excel


Formulas are used to specify calculations based on values in designated cells. Excel supports basic calculations as well as statistical, trigonometric and other specialized functions.

Formulas used in Excel must follow a certain syntax.

  1. All formulas begin with an equals sign (=).
  2. Some formulas use operands such as +,-, *,/ for addition, subtraction, multiplication or division.
    For example, the formula =A1+A2+A3 would add the contents of cells A1, A2 and A3.
  3. Other formulas refer to different functions such as SUM, AVERAGE and others.
    For example, the formula =SUM(A1:A3) would add the contents for the range A1 through A3.
  4. Formulas can be combined with operands.
    For example, the formula =10*SUM(A1:A3) would add the contents cells A1 through A3 and multiply them by 10.
  5. Functions can be nested within each other.
    For example, the formula =SQRT(10*SUM(A1:A3)) would take the square root of ten times the sum of cells A1 through A3. When functions are nested, it is important that the number of left parentheses match the number of right parentheses.

Aug 19, 2011 | Microsoft EXCEL 2004 for Mac

2 Answers

What is excel


Hi,

Microsoft Excel is a commercial spreadsheet application . It features calculation, graphing tools, pivot tables, and a macro programming language called Visual Basic for Applications.
Microsoft Excel has the basic features of all spreadsheets, using a grid of cells arranged in numbered rows and letter-named columns to organize data manipulations like arithmetic operations. It has a battery of supplied functions to answer statistical, engineering and financial needs. In addition, it can display data as line graphs, histograms and charts, and with a very limited three-dimensional graphical display.

Regards,
Shrey

Jun 04, 2011 | Microsoft Excel for PC

6 Answers

I have forgot my excel password how do i open the sheet


Excel Password Recovery 2009

This Excel add-in (password.xla) works fine in Excel 5.0 and above (including Excel 2000, XP and 2003).
This program will remove passwords of any length, also passwords containing special characters.

zipped: password.zip

Mar 06, 2009 | Microsoft Word 2000 for PC

5 Answers

Excel System error &H80004005 error


Hello dear
I am also getting same issue on excel so I was getting many problem to work in MS Excel 2007. So I have solved it this issue and I am happy to share the solution with you all.

Solution:

  • Click on Excel Button which are displaying on left top corner.
  • Click on Excel Options.
  • Then click on Add-Ins option.
  • You can find a Manage field in the bottom. Select Excel Add-Ins and click on Go button
  • You will find a Add-Ins window. Please un-check all Add-Ins except Analysis toolpak and Analysis toolpak VBA.
  • Click on OK button.
  • Close excel file and open again excel file.
Now you will resolve this issue and didnt get any problem again.

Thanks

Muhammad Waseem Alvi
Software Configuration Management Engineer
Lahore - Pakistan

Dec 03, 2008 | Microsoft Office Professional 2007 Full...

1 Answer

BASIC EXCEL FORMULA


Are you looking to solve any particular problem?--- because there are a huge number of possible formulas in Excel.

However, in my opinion, the most commonly needed ones are addition, subtraction, division, multiplication, and summing.

Suppose you have the following numbers typed into your Excel spreadsheet:

columns: A B C D
rows
1 20 3
2 10 4
3 15 2
4 1 2 3


Then suppose you type in the following formulas (in the D column):

columns: A B C D
rows
1 20 3 =A1+B1
2 10 4 =A2-B2
3 15 2 =A3*B2
4 1 2 3 =sum(A4:C4)


Then the following answers will appear in the D column:

columns: A B C D
rows
1 20 3 23
2 10 4 6
3 15 2 30
4 1 2 3 6

Sep 29, 2008 | Microsoft Business & Productivity Software

1 Answer

Computer


Any formula in Excel starts with the equals sign ("="). This is how Excel distinguishes between formulas and literal values. Knowing this, you can create lots of formulas using the usual operators of +, -, * and / for addition, subtraction, multiplication and division, respectively. Please see the examples below.

Add 1 + 1: =1+1
Add the contents of cell A1 to the contents of cell B1: =A1+B1

Subtract 2 - 1: =2-1
Add the contents of cell A1 from the contents of cell B1: =B1-A1

Multiply 1 times 2: =1*2
Multiply the contents of cell A1 times the contents of cell B1: =A1*B1

I hope this resolves the question. If not, please let me know.

Aug 08, 2008 | Microsoft Business & Productivity Software

1 Answer

Work day


Hi Chinnu,

For this you will have to install an Add-in called Analysis Tool Pack.

Kindly follow the below instructions:

1. Open Excel Options (Menu-Excel Options)
2. Click on Add-Ins on the side pane of the Excel Options Window
3. Check to see if Analysis ToolPak is in Inactive application add-in list.
4. If is not, proceed to Step 7
5. If it is in the inactive application add in list, Select Excel Add-ins against Manage and click on "Go"
6. In the add-ins menu check Analysis ToolPak and Analysis ToolPak VBA and click OK
7. Use this formula to find the number of work days excluding Saturday & Sunday in a month

=NETWORKDAYS(start_date,end_date, [Holidays])

In your case give the start date as 1st July and end date as 10th July and Holidays as 0 or 1 (doesn't matter). The answer it will return will be 8 days.

Trust the above helped.

Jul 23, 2008 | Microsoft Office Professional 2007 Full...

Not finding what you are looking for?
Business & Productivity Software Logo

Related Topics:

49 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Business & Productivity Software Experts

Brian Sullivan
Brian Sullivan

Level 3 Expert

27725 Answers

Les Dickinson
Les Dickinson

Level 3 Expert

18298 Answers

Tony

Level 3 Expert

2598 Answers

Are you a Microsoft Business and Productivity Software Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...