How to Calculate Average Percentage in Excel

How to Calculate Average Percentage in Excel

Posted on

Knowledge of How to Calculate Average Percentage in Excel will be very useful for you. If you are a teacher, you can quickly manage your report card recap using this feature of excel.

The way it works in finding the average value in Microsoft Excel is basically the same as when you calculate it manually. The problem is when you calculate it manually, it will take you a lot of time.

Therefore, some people who want to calculate the average value now rely more on the help of Microsoft Excel. Besides not taking a lot of time, calculating the average value using Excel can reduce the possibility of errors in calculations.

You can use this method to calculate the average grade on student report cards, calculate the average employee salary grade, calculate financial data, and much more.

Average Formula in Microsoft Excel

This method of calculating the average value in Excel can be used in any version of the Microsoft Excel application. All you need to prepare is an excel file that you want to calculate the average value for.

There are 2 ways to be able to find the average amount in Microsoft Excel. The first is that you will find the average of the values ​​across the row. Meanwhile, the second is to find the average value of the column.

Also Read: How to open Password Protected Excel File

The following is a brief review related to adding values ​​in Microsoft Excel so that you can get average scores easily and quickly.

How to Calculate Average Percentage in Excel

How to Average a Row in Excel

This method of calculating the average value in excel rows means that the data you are looking for is in the form of rows from top to bottom. Here are the steps:

  • Create a new line to fill in the average value.
  • In the example image below the value, data is in C2 to C11.
  • Type in a new line with the formula = average (C2: C11)
excel average multiple ranges
  • Finally, press the Enter key on the keyboard.

Done, you have got the average value in excel according to the row data. Adjust the formula to rows in your own excel data.

Also Read: How to Create a Google Form on PC or Your Phone

Meanwhile, if you have data in a large number of columns, you can click and hold then slide it sideways to get the same formula quickly.

how to calculate average of text in excel

How to Calculate Average in Excel Columns

To find the average value of data in column form is basically not much different from the previous method in the form of rows. However, you must put the position of the formula in the new column.

Here’s how to use the excel average formula:

  • Create a new column to place the average values ​​in.
  • For example, the value data is in C2 to G2.
  • Type the following formula in new line = average (C2: G2)
how to calculate daily average in excel
  • Finally, press the Enter key on the keyboard.
  • Done.

After you press the Enter key, the average value will appear according to the data in the column. Just define the formula according to the data in your excel file.

Also Read: How to Create a Watermark and Remove in Word

If you have a large number of rows of data, you can click and hold and then slide downwards to get the same average calculation formula quickly without having to type one by one.

percentage formula in excel

That’s a way How to Calculate Average Percentage in Excel in rows or columns. Simply arrange the formula according to the rows or columns of data you have to find the average value.

Leave a Reply

Your email address will not be published. Required fields are marked *