Excel formulas you should know

Download video : Formulas you should know

Download excel file : Formulas you should know

SUMIF

=SUMIF($A$5:$A$14;C5;$B$5:$B$14)

SUM

=SUM($C$5:$C$14)

CONCATENATE

=CONCATENATE(A7;”, “;B7;”, “;D7)

VLOOKUP

=VLOOKUP(G8;$A$4:$E$14;2;FALSE)

UPPER

=UPPER(A9)

REPT (font MT Extra) |||

=REPT(“|”;D10/50)

IF

=IF((SUM($C$5:$C$14)>$E$11);”Pass”;”Fail”)

AVERAGE

=AVERAGE($D$5:$D$14)

LEN

=LEN(A13)

COUNT

=COUNT(D4:D14)

#functions_excel #excel_tips #criteria #softexperia