How to use SUM, SUMIF & SUMIFS in Excel ? Excel | Excel in Tamil | Excel Tamizha | Shortcuts | Easy

 How to use SUM, SUMIF & SUMIFS in Excel ? Excel | Excel in Tamil | Excel Tamizha | Shortcuts | Easy





The SUM function is used to sum values. You can enter individual values, cell references, ranges, or a combination of the three.

As an example:

=SUM(A2:A10) adds the values from cells A2 to A10.
=SUM(A2:A10, C2:C10) The values in cells A2:10 are added, as are the values in cells C2:C10.


The SUMIF function is used to total the values in a range that fit the conditions you provide. For example, assume you wish to sum only the values that are greater than 5 in a column of integers. The following formula can be used: 

=SUMIF(B2:B25,">5")

You may apply the criterion to one range and total the associated data in another range if you like. The formula =SUMIF(B2:B5, "John", C2:C5), for example, adds just the values in the range C2:C5, when the corresponding cells in the range B2:B5 equal "John."



One of the math and trig functions, the SUMIFS function, sums all of its parameters that match several requirements. For example, you might use SUMIFS to count the number of merchants in the country that (1) live in a single zip code and (2) have earnings that surpass a certain amount.


=SUMIFS(A2:A9,B2:B9,"=A*",C2:C9,"Tom")

=SUMIFS(A2:A9,B2:B9,"<>Bananas",C2:C9,"Tom")







Comments

Post a Comment

Popular posts from this blog

How to use VlookUp & HlookUp in Excel ?? Vlookup | Hlookup | Excel in Tamil | Excel Tamizha | Easy

Image
How to use VlookUp & HlookUp in Excel ?? Vlookup | Hlookup | Excel in Tamil | Excel Tamizha | Easy The VLOOKUP function, in its most basic form, says: =VLOOKUP(What you want to look up, where you want to look for it, the column number in the range holding the value to return, return an Approximate or Exact match – specified as 1/TRUE or 0/FALSE).  Here is Video for an Example  Where do I begin? In order to construct the VLOOKUP syntax, you will need four pieces of information: 1.The value to search up, also known as the lookup value. 2.The range containing the lookup value. For VLOOKUP to perform properly, the lookup value should always be in the first column in the range. For instance, if your lookup value is in column C2, your range should begin with C. 3.The number of the column in the range that includes the return value. If you provide B2:D11 as the range, for example, you should count B as the first column, C as the second, and so on. 4.You can optionally select TRUE...
Read more

How to use IF & IFS Formula in Excel | IF , IFS | Excel in Tamil | Excel Tamizha | VBA | BASIC |

Image
 How to use IF & IFS Formula in Excel  | IF , IFS | Excel in Tamil | Excel Tamizha | VBA | BASIC | Here i attached full explanation in Tamil The IF function is a common Excel function that allows you to perform logical comparisons between a number and what you anticipate. As a result, an IF statement can have two outcomes. If your comparison is True, the first result is True; otherwise, the second result is False. =IF(C2="Yes",1,2), for example, means IF(C2 = Yes, then return a 1, else return a 2). Note: When using text in formulae, you must surround it in quotes (e.g., "Text"). The sole exception is using TRUE or FALSE, which Excel understands automatically.
Read more

How to use Count, Counta & Count Blank in Excel ? Excel | Excel in Tamil | Excel Tamizha | VBA |

Image
 How to use Count, Counta & Count Blank in Excel ? Excel | Excel in Tamil | Excel Tamizha | VBA | The COUNT function counts the number of cells that contain numbers as well as the number of arguments in the list. To determine the number of entries in a number field that is part of a range or array of numbers, use the COUNT function. For example, to count the numbers in the range A1:A20, enter the following formula: =COUNT (A1:A20). In this example, the result is 5 if five of the cells in the range contain numbers. THE IMPACT OF SYNTAX (value1, [value2], ...) The parameters to the COUNT function are as follows: value1 is mandatory. The initial item, cell reference, or range to count numbers within. Optional: value2,... You can count numbers for up to 255 extra objects, cell references, or ranges. Description The COUNTA function counts the number of cells in a range that are not empty. COUNTA Syntax (value1, [value2], ...) The parameters to the COUNTA function are as follows: val...
Read more