Friday, 17 February 2017

SUM Function And COUNT Function

​How to Use SUM Function Formula Using in Excel

SUM function Formula in Excel


​The SUM function Formula is one of the Most Useful function,

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)

 

No comments:

Post a Comment