Sunday, December 22

FORMULAS

SUMIF Formula In Excel

SUMIF Formula In Excel

FORMULAS, Maths
SUMIF function adds all numeric numbers in a given range of cells based on one criteria. Suppose there is name in column A and amount in column B and in column A if a name is repeating more than 1 time and you want to add all the amount It have next to column then Sumif is a best formula to make your work easy. Example as given below. PARAMETER: =SUMIF ( RANGE, CRITERIA, SUMRANGE ) IMPLEMENT: First select the range column, then select or add a criteria, then select the sum range and its done. Example are provided in image and video. FORMULA : =SUMIF(A2:A9,C2,B2:B9)
SUM Formula In Excel

SUM Formula In Excel

FORMULAS, Maths
SUM function is used to get automatic total of the numbers value in a selected range. Thereafter If you change the value in any of the selected range it will auto calculate and give you the exact final result. Please note that If there are text in some cell and some cell are with numeric value then sum function will ignore the text cells and will give you the result of numeric cells. It makes work very much easy when you have a large database. Example shown in image below. PARAMETER : = SUM ( RANGE ) FORMULA : =SUM(B2:F5)
COUNT Function In Excel

COUNT Function In Excel

FORMULAS, Statistical
Count function count how many numeric value are available in a selected range. If selected range is A2:B8 and if any cell contains text or it contain numeric value together with text or the cell is empty then the Count function will ignore all that in selected range and will count the cells that only contains the pure numeric value.. You Can also select the different range by giving separate reference . PARAMETER: =COUNT ( Value1, Value2 , Value3 ) ...... FORMULA = COUNT ( A2 : B4 , A5,:B8)
COUNT BLANK In Excel

COUNT BLANK In Excel

FORMULAS, Statistical
COUNT BLANK count the cells that are empty or not having any values from the database (array) available in excel sheet. Count Blank will give you the exact result from the selected range that how many cells are empty in this excel sheet. Example shown in the image below. PARAMETER: = COUNTBLANK ( RANGE ) IMPLEMENT: Use the function to select the range you want to find the blank cell and its done. FORMULA : =COUNTBLANK(A2:B8)
COUNTA In Excel

COUNTA In Excel

FORMULAS, Statistical
COUNTA counts the number of cells in a database (array) that are not empty. Suppose you select range A2 : C6 and in that range if 2 cells are empty then COUNTA function will not count those cells and give you the numeric result of the cells that contains any value text or numbers. You can also check by entering different range. For Example A2 : C6 + D2 : E6. Example shown in image and video PARAMETER: =COUNTA ( Value1, Value2, Value3 ) IMPLEMENT: Select the range either in value1 if your database is at the same location. But if you want to check in different range then use like this =COUNTA ( A2:B4 , A5:B8) if more you can add more range too. FORMULA (1) : =COUNTA(A2:B6) FORMULA (2): =COUNTA ( A2:B4 , A5:B8)
COUNTIF In Excel

COUNTIF In Excel

FORMULAS, Statistical
COUNTIF plays an vital role and as a result you get to know exactly how may times the value or specific word or number available in database (array). You can see how many times the criteria name available in under shown image and video explanation So at end you will be fully clarified that this particular terms exist this may times in a database and on that basis as a result you can figure it out and remove the unnecessary duplication entry. PARAMETER: = COUNTIF ( range , criteria ) IMPLEMENT : Select the range of your database, then select the criteria you want to find or simply type the criteria into double quote as explained in video. FORMULA : =COUNTIF(A2:A8,B2)
VLOOKUP In Excel

VLOOKUP In Excel

FORMULAS, Lookup & Reference
Vlookup is vertical' lookup built-in Excel function that work with array(data) that is available in excel columns. This function look-up or check the value in single column of database available in excel and returns the corresponding value from another column. The Image showing the exact example of it. PARAMETER : = VLOOKUP ( Lookup Value, Table array, Column Index, 0 or False (Exact Match) ) (more…)