Buzz
Calculating the average value for 2 columns is genuinely straightforward. However, in some cases, using basic functions may not solve the problem that you instruct the computer to perform. Below are some commonly used average calculation functions for office users and data entry. Mytour also notes that there have been numerous cases recently where the SUM function encountered calculation errors. If you encounter this error, refer to the article on how to fix the SUM function not calculating and apply the solution. Now, let's delve into our main topic for today.
Calculate the average value for 2 columns in Excel
1. AVERAGE
This is the most fundamental function in Excel that aids in calculating averages. Simply select the cell where you want to store the calculated average value and then enter
= AVERAGE(<cell 1=''>,<cell 2=''>,...,<cell n=''>)
For example, calculating the average of cells B2 and C2, with the result stored in cell D2
Or if the range is a set of cells, enter
= AVERAGE(
For example, calculating the average of the array starting from cell B2 to C3, with the result stored in cell E2
2. AVERAGEIF/AVERAGEIFS
AVERAGEIF: This function calculates the average with an added condition, allowing you to average and ignore cells that violate the specified condition
Select the cell to store the average value and enter
= AVERAGEIF(
For example, calculating the average of the array starting from cell B3 to C3 with the condition not equal to 0, with the result stored in cell D3
AVERAGEIFS: This function is similar to the AVERAGE function but can be applied with multiple conditions
Select the cell to store the average value and enter
= AVERAGEIFS(
Note: Subarrays can be equal to the evaluation array
For example, calculate the average of the array starting from cell B2 to C6 with the condition not equal to 0 and less than 5000, with the result stored in cell E6
Through this article, Mytour has provided you with a method to calculate the average value for 2 columns and extend it to an array. Hopefully, this article will be helpful to you! Additionally, you can explore some tricks to enhance your Excel experience, such as increasing the number of Undos. Unlike the default limit, using the increase Undo frequency trick allows you to go back to a previous state with a much higher number of Undos. Also, pay attention to how to recover Excel 2016 files in case of errors, as working on Excel sometimes leads to corrupted files, and recovering corrupted Excel 2016 files is a priority task to update your Excel knowledge.
Finally, Mytour wants to introduce you to how to create a pie chart in Excel across various versions, helping you get familiar with creating a pie chart in Excel and updating your Excel skills.
