Sunday, August 12, 2012

Basic Excel Functions


Basic Excel Functions
Function
Meaning
=Sum(A1:A5)
Adds the total of numbers from range A1 to A5
=Average(A1:A5)
Average of numbers from range A1 to A5
=Max(A1:A5)
Shows the maximum number in range A1 to A5
=Min(A1:A5)
Shows the minimum number in range A1 to A5
=Count(A1:A5)
Calculates the number of entries in range A1 to A5


For non-continuous range, you can use comma to select different range.

 

For continuous range, you can select across different columns.


Download the file: blog_excel_work_files.xlsx from:
http://seanexcel.weebly.com/work-files.html

1 comment:

  1. Hmm this post is truly effective; you have defined the core factors in your write-up. Thanks payday installment loans

    ReplyDelete