How to summarize and average in excel?

How to summarize and average in excel?

Method for averaging by classification and summarization in excel:

In our daily life, we often use excel to make tables, but some have many When we are looking for data, we need to classify and summarize what we need and find the average. At this time, we need to use excel. Next, I will introduce to you how to set up the classification and summary in excel to find the average. I hope it will be helpful to everyone. , please follow me and look down.

1. First, let us open the excel form to be processed on the computer desktop.

#2. Continue, we expand the selection and select the data we need to classify.

#3. Secondly, let’s click the data button in the toolbar above.

#4. Next, we click the classification and summary button on the right side of the toolbar.

#5. Finally, we select the summary method as average and click OK.

Recommended tutorial: "excel"

The above is the detailed content of How to summarize and average in excel?. For more information, please follow other related articles on the PHP Chinese website!