Excel management - Using the Sum Function

40 %
60 %
Information about Excel management - Using the Sum Function

Published on March 14, 2014

Author: xclmgmttips

Source: slideshare.net


Microsoft Excel gives you the ability to count up the total of a range of cells. The advantages behind doing this are easy to see. You might want to calculate the sum total of sales or of orders or of customer complaints about scams - there are an unlimited list of things you will want to use this for. This presentation is very helpful in this regard.

Excel Management: Part II How to Use the Sum Function

Why use the SUM Function? • The values of adding cells and columns are too numerous to state here in this presentation. The simples reason is that you want to be able to count automatically without having to use a calculator and to go one by one counting up all the cells. This is because doing so will take you a lot of time and lead to incorrect results. Incorrect results lead towards scams and frauds when you charge customers incorrect amounts for items they purchase or other similar issues.

How to Implement This Function • It is very simple. Let’s say you have a list of values from cell A2 – A9 – these all list the number of bills that your client has yet to pay you for. If you want the total to be calculate on A10 (or A11) go to that cell and type in the following: =SUM(A2:A9). • Try it out and thank us later for this great tip!

Add a comment

Related presentations

Related pages

Excel management - Using the Sum Function ...

Excel Management: Part II How to Use the Sum Function Why use the SUM Function? • The values of adding cells and columns are too numerous to state here ...
Read more

Sum Columns or Rows of Numbers with Excel's SUM Function

Using shortcuts to Excel's SUM function makes it easy to quickly sum or add up columns, rows, ... Excel Data Management; Excel Charts and Graphs;
Read more

Excel DSUM Function Tutorial and Example - About.com Tech

Example Using Excel's DSUM Function ... we could use the regular SUM function, ... Excel DSUM Function Tutorial
Read more

Using Basic Functions in Excel | Training Connection

Project Management; Time ... Areas; Chicago; Los Angeles; Home / Excel / Basic Functions Using Basic Functions in Microsoft Excel. ... Using the SUM Function.
Read more

SQL: SUM Function - TechOnTheNet

The SQL SUM function is used to return the sum of an expression in a SELECT statement. ... Excel; Access; Word; Web Development; HTML; CSS; ... Using Formula .
Read more

How to use Excel: Tutorial 10 - Using the SUM function

Online Learning for Sports Management. ... Tutorial 10: Using the SUM function. ... a button on the Home Ribbon of Excel that is dedicated to this function.
Read more

Sum data by using a query - Access - support.office.com

Sum data by using a query. ... results in a grid that resembles a Microsoft Office Excel 2007 ... document emphasize using the Sum function, ...
Read more

Excel Functions and Formulas

Excel Sum Function Excel Countif ... help with Excel functions and ... in the most recent versions of Excel. If you are currently using an older version ...
Read more

SQL SUM() Function - w3schools sql sum

The SUM() Function. ... The following SQL statement finds the sum of all the "Quantity" fields for the "OrderDetails" table: ... While using this site, ...
Read more