Math Functions in EXCEL SUM

Add of data from C2 to C9 (Rates) =sum(C2 : C9)

Math Functions in EXCEL AVERAGE

Average of data from C2 to C9 (Rates) =average(C2 : C9)

Math Functions in EXCEL MAX

Maximum of data from C2 to C9 (Rates) =max(C2 : C9)

Math Functions in EXCEL MIN

Minumum of data from C2 to C9 (Rates) =min(C2 : C9)

Math Functions in EXCEL COUNT

Counts of data from C2 to C9 (Rates) =count(C2 : C9)

Math Functions in EXCEL SUMIF

Sum of data from C2 to C9 (Rates only for Shoes) =SUMIF(A2:C9,"shoes",C2:C9)

Math Functions in EXCEL SUMIFS

Sum of data from C2 to C9 (Rates only for Shoes with brand of Bata) =SUMIFS(C2:C9,A2:A9,"Shoes", B2:B9,"Bata")

For More please visit egyanvani.com

Thanks for watching.