Excel2010 function summation, averaging

Source: Internet
Author: User

The sum of some data that is often used in Excel, the order of average, such as the total sum of the students ' scores and the average score of the class. So how do you do it? In Excel2010, the method of calculating the average value with function automatic table is as follows:

Step one: The first thing to know is the sum of the function is sum. Calculate the sum of the following data as shown in the figure.

Step two: In the total score of the cell (B12), the input function "=sum (B2:B11)" Why to enter this function value. Sum is the SUM function value, followed by the total value from cell B2 to B11. Believe that this should always understand why the input of the B2:B11, if you ask for personal score, in the D2 cell input "=sum (B2:B3)", very simple bar. As shown in the figure:

Computer Tutorials

So how do you mean it? In fact, the method is the same, but the average function is not sum, is the "AVERAGE" function, then directly to the sum into the acerage function can be. As shown in the figure:

Of course ecxel2010 we sometimes in the sum of the time to use the SUMIF, the SUMIFS function, the specified cell to sum the function, all, this use of the method to see how the user changed their operation, the method of averaging is the same. Look at the function's words directly in the Start menu's "formula" option. The above is Excel2010 with function automatic table summation, the average operation of the relevant content, hope to help users.

Related Article

E-Commerce Solutions

Leverage the same tools powering the Alibaba Ecosystem

Learn more >

Apsara Conference 2019

The Rise of Data Intelligence, September 25th - 27th, Hangzhou, China

Learn more >

Alibaba Cloud Free Trial

Learn and experience the power of Alibaba Cloud with a free trial worth $300-1200 USD

Learn more >

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.