Formulas for Sales spreadsheet

I need some suggestions from the community. I'm doing a spreadsheet for the Sales department in the company.

I have used formulas such as AVERAGE , MAX , MIN , SUM. This are considered Basic formulas.

I also used VLOOKUP, SUMIF, COUNTIF, AVERAGEIF , SUMIFS , COUNTIFS. This are considered advanced functions.

I need 3 additional formulas. and for that , i used ROUND and RANK.

I need 1 more formula. Can someone suggest to me what formula is suitable?

This is urgent. Thanks!

check the function of excel , you can use median ? who or what number is in the middle ,

Originally Posted by trucker10

check the function of excel , you can use median ? who or what number is in the middle ,

there's mean , mode , median .

What information do you need to find Standard Deviation ?