answersLogoWhite

0

What are the different ways to total values in Excel?

Updated: 8/18/2019
User Avatar

Wiki User

13y ago

Best Answer

Basically you can either add values individually, including cells:

= 1 + 2 + 3

or, to add values in cells:

= A1 + A2 + A3

Or, you can add a range of numbers, stored in adjacent cells, with the sum() function:

= SUM(A1:A10)

User Avatar

Wiki User

13y ago
This answer is:
User Avatar

Add your answer:

Earn +20 pts
Q: What are the different ways to total values in Excel?
Write your answer...
Submit
Still have questions?
magnify glass
imp
Related questions

Why is Excel is ideal for what if analysis?

Spreadsheet applications are ideal for What-If Analysis. Excel lets you put in different formulas and different values for those formulas and then you can analyse the results when different combinations of values are used. All of this can be very quickly changed and different functions and features can be used to enhance this process, giving Excel a wide range ways of doing What-If Analysis effectively.


How many different format choices are there for time in Excel?

In MS Excel 2010, there are 8 ways to format Time Cells


What are different ways to maintain peace?

Some ways to maintain peace include promoting dialogue and understanding among conflicting parties, practicing empathy and tolerance, supporting conflict resolution mechanisms such as mediation and negotiation, and fostering a culture of non-violence and respect for diversity.


What are four different ways laws bring about order?

Morals, values, beliefs, and customs


What is the formula for finding out probability?

(number of different ways it can succeed) divided by (total number of different ways it can happen)


Is there a wrong way to enter a function in excel?

Each function has to be put in correctly. Some formulas have different requirements than others. They may need values to work on. If they are not provided properly, then the functions won't work. So yes, there are many ways that a function can be entered wrongly.


Can Excel add values in one column based on the data in another column?

Yes it can. There are various ways of doing it, which would depend on the specific situation. You can use functions like IF and SUMIF to do it.


How does Microsoft Excel help an enterprenuer?

Excel has a huge amount of uses so it can be of use to an entrepeneur in many different ways. It could be used for accounts, working out sales for products, possibly in some aspect of the creation of their products. Excel is for numerical analysis and manipulation. So anything to do with numbers can be done in Excel.


What are the traditions and values of the African peoples?

Africa is made of many different cultures and ethnicities. Some of them are similar in very small ways, but otherwise, there is no one ultimate culture or set of values.


Do people differ?

People are different in many ways. People are different in their values, morals, and personality. People are also different in the way they look, act, and speak.


Is the mean and median the same?

No, they are both averages but worked out in different ways and give different answers. The mean is the sum of all the values added together and then divided by the number of values there are. The median is found by arranging the values in numerical order and finding the number in the middle.


What does mean value in science mean?

the mean is the average of the numbers. It is one of several different ways of determining the average of a set of values. It is determined by adding the sum of all of the values, then dividing by the number of values.