​How to Use SUM Function Formula Using in Excel

​Sagar Guide - How to Use SUM Function Formula Using in Excel

SUM function Formula is most useful and easy formula in Excel


Syntax: SUM(number1,[number2],...)

For example 1:  Adding + Count
      A        B             C (Result)
   2111    25447        27558        

Adds the value in cells A1 and B1. The result is 27558

Formula  : =SUM(A1+B1)
                  =SUM(A1:B1)


For example 2:  Deducting - Count
      A           B             C (Result)
   25447    2111          23336        

Adds the value in cells A1 and B1. The result is 23336

Formula  : =SUM(A1-B1)

Example 3

     A              B        C (Result)
    15             25         40

Formula =SUM(A2,A3)Adds the value in cells A1 and B1. The result is 40.
How to Use COUNT Function Formula in Excel
The COUNT Function Formula is counts the number of cells that contain numbers, and counts numbers within the list of arguments.

Use the COUNT function to get the number of entries in a number field that is in a range or array of numbers. For example, you can enter the following formula to count the numbers in the range A1:A20:.

For Example : 1

  A
​582
258
2458
584
585
655
698
4785
145
1256
2256
2545
2564
2548
1525​

Result  = 15

COUNT Function Formula

=COUNT(A1:A15)


For Example : 2

    A           B                    C    (Result)
​582         252                 2
258         352                 2
2458       452                 2
584         552                 2


COUNT Function Formula

=COUNT(A1:B1)