How do you find the average of a specific criteria in Excel?
Show For calculating average in a column based on same values in another column (see screenshot below), what can you do? In this article, we will show you two methods to get it down in details. Calculate average in a column based on same value in another column with formulas Calculate average in a column based on same value in another column with formulasYou can calculate average in a column based on same value in another column with formulas. Please do as follows. 1. Select a blank cell, enter the below formula into it and press the Enter key. =AVERAGEIF(B2:B13,E2,C2:C13) Note: in the formula, B2:B13 is the range contains the criteria, C2:C13 is the range contains the data you want to calculate average, “Owenton” is the value you will calculate based on. You can change them as you need. Now the sales average of “Owenton” is calculated. For calculating the average of other values in column B, you need to repeat the above operation until all value average are calculated. Calculate average in a column based on same value in another column with Kutools for ExcelThis section will show you how to calculate all average in a column based on same value in another column at once in Excel. Before applying Kutools for Excel, please download and install it firstly. 1. Select the range, and then click Kutools > Merge & Split > Advanced Combined Rows. 2. In the Combine Rows Based on Column dialog box, please configure as follows:
Now the averages in column C are calculated based on the same values in column B. see screenshot: If you want to have a free trial ( 30-day) of this utility, please click to download it, and then go to apply the operation according above steps. Calculate average in a column based on same value in another column with Kutools for ExcelThe Best Office Productivity ToolsKutools for Excel Solves Most of Your Problems, and Increases Your Productivity by 80%
Office Tab Brings Tabbed interface to Office, and Make Your Work Much Easier
Comments (3) No ratings yet. Be the first to rate! How do I find the average of only certain values in Excel?Use AutoSum to quickly find the average. Click a cell below the column or to the right of the row of the numbers for which you want to find the average.. On the HOME tab, click the arrow next to AutoSum > Average, and then press Enter.. How do you average cells based on criteria?=AVERAGEIF(range, criteria, [average_range])
The AVERAGEIF function uses the following arguments: Range (required argument) – This is the range of one or more cells that we want to average. The argument may include numbers or names, arrays, or references that contain numbers.
How do you average values based on criteria in another column in Excel?Average Cells with Data -- AVERAGEA. Enter the sample data on your worksheet.. In cell A7, enter a AVERAGEA formula, to average the numbers in column A: =AVERAGEA(A1:A5). Press the Enter key, to complete the formula.. The result will be 16.38, the average of the cells that contain data.. How do you calculate the average of multiple criteria in Excel?If you want to calculate average with multiple criteria, the Averageifs function may help you. The Averageifs syntax as follows: AVERAGEIFS(average_range,criteria_range1,criteria1,criteria_range2,criteria2…)
|