10 Most Important Excel Formula || Sum, Average, Count, Max, Min, Large, Small, Rank
Uploaded on 11 December 2019
By: Md. Abdur Rahim Farhad
Facebook Group: / 1586833524955209
Facebook Page: https://www.facebook.com/MS-Excel-Tri...
1. SUM:
=SUM(Total Range) & Enter
2. Auto SUM Function:
---GO Home & follow top formula --- then Click Auto SUM & Enter
3. SUM Using Keyboard:
Alt += & Enter (Click Alt & at a time click += then enter)
4. Average:
=Average(Array) then Enter
5. Count:
=count(Array) then enter
6. Max:
=max(array) then enter
7. MIN:
=min(array) then enter
8. Large:
=large(array,select specific number) then enter
9. SMALL:
=small(array,select specific number) then enter
10. RANK:
=rank(select specific number, array, 0) then enter.
Subscribe & follow facebook page with group.
Thank you.
Stay with me.