Excel Tamizha

 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...

  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 ...

 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.