Question about Microsoft Computers & Internet

Sum function how to use sum function and formulas

Posted by on

• Level 2:

An expert who has achieved level 2 by getting 100 points

MVP:

An expert that got 5 achievements.

Vice President:

An expert whose answer got voted for 100 times.

Governor:

An expert whose answer got voted for 20 times.

• Expert

Write down the number in cells for Example:

A1 (59)   Without Brackets
A2 (50)
A3 (80)
A5  ?    ANY Number
A6  ?    ANY Number
A7  ?    ANY Number

A8 =SUM(A1:A7)     you will get total sum of above numbers on                                   this A8 Cell which is auto sum whenever you                                 change the value on above cell.

Posted on Feb 22, 2009

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).
goodluck!

Posted on Jan 02, 2017

×

my-video-file.mp4

×

Related Questions:

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

Tip

HOW TO COUNT THE OCCURRENCES OF A TEXT STRING

In the cell that you want the result to appear in, enter the appropriate formula from the following examples.
How to Count the Occurrences of a Number
Use this formula
=SUM(IF(range=number,1,0))
where range is the range that you want to search, and number is the number that you want to count.
NOTE: This formula must be entered as an array formula. To enter an array formula, press CTRL+SHIFT+ENTER.
How to Count the Occurrences of a Text String
Method 1
Use this formula
=SUM(IF(range="text",1,0))
where range is the range that you want to search, and text is the text that you want to find (the text must be enclosed in quotation marks).
NOTE: The above formula must be entered as an array formula. To enter an array formula, press CTRL+SHIFT+ENTER.
Method 2
Use the COUNTIF() function to count the occurrences of a text string. For example, use the formula
=COUNTIF(range,"text")
where range is the range of cells that you are evaluating, and text is the text string that you want to count instances of (note that text must be enclosed in quotation marks).
NOTE: This formula must be entered as an array formula. To enter an array formula, press CTRL+SHIFT+ENTER.
Wildcard characters can be used within the COUNTIF function.
The asterisk character (*) represents more than one character. For example, to count all the cells in the range a1:a10 that contain an "x," you can use the following formula:
=COUNTIF(a1:a10,"*x*")
The question mark character (?) can also be used to represent one wildcard character -- for example, to count all cells in the range whose second character is the letter, such as "ax" or "bx."
=COUNTIF(a1:a10,"?x*")

on Nov 11, 2013 | Microsoft Excel Computers & Internet

How do i insert a formula in a column to add each number & give a total at the bottom?

For example, you have three numbers from A1 to A3. On row A4, type =SUM(A1:A3).

That should do it. :)

Sep 16, 2009 | Microsoft Office Excel 2007

Sumif function....

Use the following formula as an array formula, you need to hit "Shift+Ctrl+Enter" after entering the formula. Lets say you have the Name in column "B", the Age in column "C" and the amount paid in column "D". Here is the formula.
=SUM((B2:B7="Abhilash")*(C2:C7>0)*(D2:D7))

It will calculate the amount paid if the name =Abhilash" and the Agr is greater than zero.

Apr 11, 2009 | Microsoft Works 8.0 for PC

CAN GET COLUMNS TO ADD UP AND GIVE TOTAL ONLY GET SUBTOTALS

Use the function =sum() to add numbers. To sum, for example, all of column A, enter in the formula bar =sum(\$A:\$A). You can use the subtotal function within the range you are adding and the answer will not count towards the final total.

Mar 14, 2009 | Microsoft Excel for PC

How to do profit and loss a/c in ms excel

Hi saleem_share,
I'm not sure why you would want to use excel to create a P&L, but the same formula would apply to excel as it would for a standard P&L. In one section of the spreadsheet add all of your income accounts. Then Subtract your cost of sales from that. That would equal your Gross Profit. After that add all the rest of your Expenses, and subtract from the Gross Profit, which would give you your net Profit or Loss Example:
Description
Amount
Formula
Sales Product A
1,000.00

Sales Product B
1,000.00

Total Sales
2,000.00
SUM(C1:C2)
Cost of Sales Product A
500.00

Cost of Sales Product B
200.00

Total Cost of Sales
700.00
SUM(C5:C6)
Gross Profit
1,300.00
SUM(C4-C7)

Auto
25.00

Utilities
50.00

Payroll
300.00

Office Supplies
20.00

Total Expenses
395.00

Net Profit
905.00
SUM(C8-C14)

I hope this helps

Mark

Jan 05, 2009 | Microsoft Computers & Internet

Formula for calculating the days beween months

for example, cell A1 has date (01-01-2008) and cell A2 has current date (08-24-2008) and cell A3 shows total days, is that you want to know? if yes, apply formula as under...

cell A3......(properties set as General to show digits)................ =SUM(A2-A1)

Aug 25, 2008 | Microsoft Office Professional 2007:...

Microsoft works

First check the formatting of the cells, then check under file-preferences to see what works is programmed to do, if this gives no clue, you could easily create a copy to experiment on and on the copy, highlight the entire sheet, and clear all functions and formats, then experiment with your calculation, if it performs ok, you will know that there was something else going on in the original cells. Finally, instead of the auto-sum function you could manually put in the sum formula eg D2=sum ( A34:A57)
If all this fails, post back and we'll dig further......good luck

Jan 03, 2008 | Microsoft Works 8.0 for PC

Excel and the AVERAGE function

Here is one way:

In this example, my numbers are in cells a1 through a4. My average is computed with the formula:

=SUM(A1:A4)/COUNTIF(A1:A4,"<>0")

I'm summing the range of numbers and dividing that by the count of nonzero numbers. With this formula, you'll get an error if there are no nonzero numbers.

Dec 30, 2007 | Computers & Internet

Excel Formula

columns total in additin cells of rows equal are total

Oct 24, 2007 | Oracle 10g Database Standard (ODBSEONUPP0)

Open Questions:

Related Topics:

132 people viewed this question

Level 3 Expert

Level 3 Expert

Level 3 Expert