 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 …

## HLOOKUP in Excel – Explanation with example 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 …

## VLOOKUP in Excel – Explanation with example 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 …