The Excel SUM Formula is used, where we need to do the sum of the numerical values in the selected range, cells reference or table column/row. It can sum together the numerical values in the multiple selected ranges or cells Read More …
The Excel COUNT Function is used, where we need to count the number of numbers in the selected range or cells reference. It can count together the numerical values in the multiple selected ranges or cells references. With the help Read More …
Excel COUNTIF Function: – The Excel COUNTIF Function is used where we need to count the numbers of repeated values on single criteria. It can count the value of the cells based on a condition of any Text, number and logical text. Read More …
Excel Index Function:- The Excel Index function is used to find out the value in a selected array or range by giving a position of the cell in the selected array. We will direct the excel to find out the value of Read More …
Excel Match Function:- The Excel Match function is used to find out the position of the selected value in the selected array. The position of the selected value may be exact matched, less than and more than from the value. Read More …
The Excel SUMIF Function is used where we need to sum up the value on single criteria. It can be sum up the value of the cells based on a condition of any Text, number and logical text. It is also working Read More …
IF Function in Excel: – The “IF” Function in Excel is a logical test, which represents the result in two way if the logical condition true and false. There is always two way of getting the value, one is when we Read More …
HLOOKUP in Excel: In the HLOOKUP Function “H” stand for horizontal and with the help of this formula, we can retrieve the matched value from the selected cells(table array) from up to down means in horizontal order. It supports approximate Read More …
What is VLOOKUP: – In VLOOKUP, V stands for vertical and with the help of this formula, we can retrieve the matched value from the selected cells(table array) from left to right means in vertical order. It supports approximate and exact Read More …