Most Important Formulas In Excel

Most Important Formulas In Excel

Hello Viewer,
The Main motive of this blog is to share the knowledge of Excel with the all those who want to learn Excel.
In this blog, all the Excel formulas have been explained in an easy way,
Like - [SUM, SUMIF, SUMIFS, COUNTBLANK, COUNT, COUNTIF,VLOOKUP, TRIM, LEN etc...]

SUM
The SUM unction to add cells in a range.
You can add individual values, cell references or ranges
For example: =SUM (B3:B11)
SUM

SUMIF
The SUMIF function to add cells in a range that meet a single condition.

SUMIF

SUMIFS
The SUMIFS function returns the Sum of cells that meet one or more criteria.

SUMIFS

COUNT
The COUNT function returns the count of Numeric Values Only.
COUNT

COUNTA
The COUNTA function returns the count of Numeric Values Only.
COUNTA

COUNTBLANK
The Excel COUNTBLANK function returns a count of empty cells in a range.
COUNTBLANK

COUNTIF
The COUNTIF function to count cells in a range that meet a single condition.
COUNTIF

COUNTIFS
The COUNTIFS function returns the count of cells that meet one or more criteria.
COUNTIFS

VLOOKUP
VLOOKUP function says: =VLOOKUP(What you want to look up, where you want to look for it, the column number in the range containing the value to return, return an Approximate or Exact match – indicated as 1/TRUE, or 0/FALSE)

VLOOKUP Syntax =VLOOKUP(value, table, col_index, [range_lookup])

VLOOKUP

TRIM
The formula syntax and usage of the TRIM function in Microsoft Excel. Description. Removes all spaces from text except for single spaces between words.

TRIM Syntax =TRIM (Text)
TRIM

LEN
LEN Formula returns the number of characters in a text string.
LEN Syntax =LEN (Text)

LEN

☺We Are Working on it..................

Comments