Showing posts with label SUM. Show all posts
Showing posts with label SUM. Show all posts

SUM

 SUM  - to sum/calculate a total of numbers. Example of formula would be =SUM(Range X:Range Y)


  Example 1




Select row or column to calculate the total of values. In this example, the row of values would be A2 to A7. 


To calculate the total values, type =SUM(Range X:Range Y) in the destination cell to display. In this example, it would be =SUM(A2:A7). Hit Enter to display the calculation result.


Example 2

We can also use SUM to calculate the total of multiple rows or column. For example, this row A and row B. 


We're going to calculate values in column A and column B. 


In selected cell for display value, type =SUM(A2:B7). Hit Enter to calculate the result.




Labels: ,
Subscribe to: Posts (Atom)

Shortcut to use in Microsoft Office 1

There are shortcuts that you can use in Microsoft Office to fasten your work. You need to press the same keys together. 1) Ctrl + A - to sel...

  • MIN
     Formula MIN is used to search the least value. Example of formula is =MIN(RANGE X:RANGE Y) Example 1 : To find the minimum value of a row ...
  • AVE
    Formula  AVERAGE  is used to search the average value. Example of formula  is  =AVERAGE(RANGE X:RANGE Y) Example 1 : To find the average val...
  • Using '&' in Microsoft Excel
    To connect strings in Microsoft Excel, simply use '&'.   Example : This will return the following results: