Returns the average value for the items in the list, list. You can use the AVERAGEIF function to calculate the average lookup value. I am wanting to do an averageifs statement, but it does not seem that is supported. 3. For example, you need to calculate the average of three date’s quantity of Apple excluding zero cells in the table, you can apply the following formula. Otherwise it increases the value of the previous cell by 1. We covered all possible comparison operators in detail when discussing Excel SUMIF function, the same operators can be used in SUMIFS criteria. In this example, we will demonstrate the use of the AVERAGEIFS function based on multiple criteria. Your sheet structure could be improved to make analysis much more efficient. =AVERAGEIF (B5:E9,"<>0") Next, press the Enter key and this will find the Sales Average inside cell D10. 2. The answer should be 4. The result is the average of values in group "A" for all three months of data. Excel AverageIf to get total average of multiple rows from a table. Columns(20), _. Type =AVERAGEIFS. Averageifs for multiple criteria. You can apply the AVERAGEIFS function on a single column to calculate the average. Then we create a COUNTIF function to count the number of records that appear more than once: =count. Returns the average of a data column depending on multiple criteria. This cell range contains multiple columns. Specifying Multiple Range. The AVERAGEIFS uses the following syntax: average_range, criteria_range1, criteria1, criteria_range2, criteria2, etc. In this example, the goal is to calculate an average of the quiz scores in columns C, D, E, and F for each person. The result is the average of values in group "A" for all three months of. COUNTIF: Returns a conditional count across. Here, cell range B5:B13 is selected as criteria_range1, and cell range C5:C13 is selected as criteria_range2. g. Type the formula ‘=VSTACK (‘ to start the VSTACK function in Excel. AVERAGEIFS(table_name!price, table_name!fruits, “Apple”, table_name!inventory,. 0. FORMULA. Is there a simple way to copy the formula over and have the column numbers move four across to average subsequent years?In this example, the goal is to calculate an average of the quiz scores in columns C, D, E, and F for each person. AverageIFs multiple columns when meets multiple criteria in one column. ) The AVERAGEIFS function syntax has the following arguments: Use this array formula: =AVERAGE (IF ( (ISNUMBER (MATCH (B2:B10, {"Emp1","Emp2","Emp3"},0)))* (C2:G10<>""),C2:G10)) Being an array formula it must be confirmed with Ctrl-Shift-Enter instead of Enter when exiting edit mode. But as demonstrated below, they do not. As the formula is copied down, it returns total hours in Sheet1, Sheet2, and Sheet3 for the projects shown in column E. Problems averaging multiple columns using AVERAGEIF and AVERAGEIFS . Example 1: AVERAGEIFS with One Character Column. One approach is based on the AVERAGEIFS function, which is designed to calculate averages using multiple criteria. You can use the following methods to write AVERAGEIF and AVERAGEIFS functions using VBA in Excel: Method 1: AVERAGEIF Function in VBA. =AVERAGEIF(B2:H11, “<60”) The formula above only takes into account and finds the average of the four highlighted values — 54, 49, 56, and 0. Using =averageifs with multiple text criteria in different columns. The generic syntax for AVERAGEIF looks like this: = AVERAGEIF ( range, criteria, average_range) The AVERAGEIF function takes three arguments: range, criteria, and. criteria_range1 is required. Aug 2, 2017 at 10:41. In this video show you how to calculate the average values across multiple columns with a filterin. Coachcasa New Member. . ; The function treats the cell as a ‘0’ value if any cell in the criteria range is empty. Note that, we have changed the column 1 title from Month to Month Number so as to include the numbers inside the formula. Using AVERAGE and IF Functions For instance, to average the sales in column C if the date in column B is between 1-Sep and 30-Oct, the formula is: =AVERAGEIFS(C3:C15, B3:B15, ">=9/1/2022", B3:B15, "<=10/30/2022") With cell references: =AVERAGEIFS(C3:C15, B3:B15, ">="&E3, B3:B15, "<="&F3) This article describes the formula syntax and usage of the AVERAGEIFS function in Microsoft Excel. =AVERAGE (column_references) ARGUMENTS. So, one thing I'm thinking is that your lookup has no records or you have a mispelling. The is “Vegetables”. Here's the formula I'll use: =COUNTIF (C2:C17,">100") This is a simple, two part formula: simply point Excel to the list of data to count, and the rule to count. g. Select Done to complete the function. In Excel, it’s not possible to use the AVERAGEIF () function to calculate an average value using multiple ranges. Stack Overflow. The following examples show how to use each formula in practice. 7. Here, we will find out the average of goals when Goals number is at least 1, and when the Venue is Home. 0. I used the TODAY function to indicate 30. The best way to use XLOOKUP with multiple criteria is to use Boolean logic to apply conditions. For that cause, we will sum up prices horizontally and create a new column named Subtotal. Let’s follow the instructions below to learn! Steps: First of all, merge cells E5 to E15. 1. In this video show you how to calculate the average values across multiple columns with a filterin. Here is a screenshot to clarify. How do I `SUM` by multiple columns in Excel. I'm trying to calculate a percentage value which uses an AVERAGEIFS function. 33, or how many Man in China which should average 2. What I'm trying to do is find the average for each category, excluding the 0s. First, create a column to count how often a record appears on the data. Formula. No, just that if the first range is 1 column by 100 rows, the other ranges should also be 1 column by 100 rows. 📌 Steps: First and foremost, specify your conditions in cells B17 and C17 for better visualization. Type "," and then enter the criteria you want to use (e. There is a formula that does this for you called AVERAGEIFS. WorksheetFunction. The AVERAGEIFS Excel function helps users provide multiple criteria for a given dataset, finds the cells that fulfill all the criteria, and calculates the average of the respective cell values. You can add as many criteria_range,criteria in AVERAGEIFS. "A" and "G") may be zero. 1. I have to find average number of days where Status = new or open, Severity = 4, and Area = Apps. Now, we want to find the average price of items that are greater than 200 and less than 400 in. Can I not put multiple criteria on the same column range in an AVERAGEIFS? Wat needs to happen is that in the Columns C the program needs to calculate the average of all the values of F IF the number in E falls within the interval in Columns A and B. The result is 354,575, the average of Prices in C5:C16 when corresponding cells in D5:D16 are not blank. Type "," and then enter the criteria you want to use (e. e. We take a dataset that includes some students,. 1. When say conditional average, we think of Averageif, but in this sc. Clear search AverageIFs multiple columns when meets multiple criteria in one column. Average Based on Multiple Criteria on a Single Column. Formula Breakdown: AVERAGEIFS(D5:D14,C5:C14,C17,D5:D14,”>=”&85) → finds average for the cells specified by a given set of conditions or criteria. Is there a way to do. One approach is based on the AVERAGEIFS function,. Example 2: Using AVERAGEIFS for Multiple Columns. CountIF and AverageIF a column. Use the following formula for G1 and copy down to the bottom of your list in column G. Method-4: Find the Average of Cells That Match Text Partially. I'm trying to get excel to give me the average of multiple objects if they meet a criteria. Returns the average of a data column depending on multiple criteria. to get the average of every column of the table using a query. 4 Answers Sorted by: 1 The AVERAGEIFS criteria come through as AND conditions. This is achieved through the use of the Excel AVERAGE function. In the worksheet shown, the formula in cell H5 is: =AVERAGE(FILTER(data,group=G5)) where data (C5:E16) and group (B5:B16) are named ranges. Result. From the selected column, it will search the lookup value to calculate the average of these values. You are looking for the AVERAGEIF function seen here. how to use multiple criteria in AVERAGEIF function. This article explains how to. AVERAGEIF (range, criteria, [average_range]) The AVERAGEIF function syntax has the following arguments: Range Required. average_range is required. . When using multiple criteria, you can apply them to the same range as we did with previous. )] I hope I was able to explain what I want. How to use AVERAGEIF in Google Sheets, only addressing columns with a specific text. Thus, 5 columns are reserved for the category of a given record. See screenshot: 2. Multiple columns. AVERAGEIF based on multiple columns in google spreadsheet. I've tried using the standard AVERAGEIFS combined with the MONTH forumla, but I think the row of dates is throwing it off. Even using the 1 average column, I'd need an averageif to average the supervisor's staff's averages, unless I just want to hard-code it onto Sheet1, but I'd. Well, either SUMPRODUCT or array formula. (A$2:Z$2, rather than simply specifying the range as A2:Z2. 00, the price for a Medium Blue Hoodie. I want to calculate the average of the last column (SLA in days) for the lines. find average for multiple values in rows and columns in Excel. 2. E. You are comparing three whole columns to a range 5 columns wide and 8 rows high. Express the 1st condition ("math" or F3 - the target item enclosed in quotation marks or reference to the cell containing the item). 2. As Jeff pointed out, the function will silently resize your ranges to suit that restriction - so for example if you typed:. 67. I have attached a sample of the sheets I am using. In this case, the AVERAGEIFS function comes as a savior. Excel AVERAGEIFS Function. However, you could re-create AVERAGEIF quite easily: So the formula in G2 to re-create AVERAGEIF could be: =AVERAGE (IF (A2:A5=G1,D2:D5-B2:B5)) Note: This formula is an array formula and needs to be confirmed through Ctrl Shift Enter. It would be best if you store your variables in Cells. If you need to add two criteria, for example the average quantity of shirts that Joe orders, use a combination of AVG and. Where Column B contains the numbers being averaged, and column A is your zones. One or more cells to average, including numbers or names, arrays, or references that contain numbers. =SUMIF({Butler - PROJECT MASTER - Inte. In Column N2 and NO I put those 2 times respectively. There are two fields in the Insert Calculated Field dialog box. I have tried using the OR function, and tried the curly brackets, but both give me errors. AverageIFs multiple columns when meets multiple criteria in one column. This screenshot shows my attempt to replicate your setup: The formula in column D is based on the following steps: Find the column number corresponding to the category. For example, one formula that is in use: =AVERAGEIFS (K:K,C:C, ">=01/01/2021", C:C, "<=1/31/2021") This formula works exactly the way I want, for the data specifically only in column K. To find the average of all cells in a range L1:L10 that meet multiple conditions: =AVERAGEIFS(L1:L10,M1:M10,"oranges",N1:N10,">=5",O1:O10,"<10"). For. AVERAGEIF function on different cells in different sheets. 1 Answer. Excel: how to. AverageIfs(TempRange. 0. AVERAGEIFS with multiple criteria on one range Originally Posted. In Excel, we often need to calculate the average of multiple columns based on multiple conditions. I have 2 Tabs, Tab 1 = Multiple (2) Tab 2 = Auto Created --> lets call it "Sheet1" Sheet1: Column A - is Date (15 min interval) Column B - Lets call it "CPU" Column C -. As you have found, AVERAGEIF does not work across multiple sheets; nor do COUNTIF, COUNTIFS, SUMIF etc. 6. 1. Joined Feb 1, 2021. stack the 2 ids and 2 weights columns to create dataframe with 1 ids and 1 weight column. Average. Excel begin AverageIF function. Express the 1st condition ("math" or F3 - the target item enclosed in quotation marks or reference to the cell containing the item). Failed attempts. [SOLVED] AVERAGEIF Multiple Columns Multiple occurrences. Example 1: AVERAGEIF Function in VBA. Using SUMPRODUCT Along Multiple Columns and Rows. Method-2: Finding Average If Cell Contains Text (Multiple Text Criteria) 2. 1. I tried the following: AVERAGEIF(A:A,"<>INDIRECT(""A""&(ROW()-1))", B:B) but that doesn't seem to work and it takes all rows. You may want to make sure that the range size and shape of each column reference is the same. I want to accomplish what this formula does, but to include. The three most common measures of central tendency are: Average, which is the arithmetic mean, and is calculated by adding a group of numbers and then dividing by the count of those. If you want to do the same with AVERAGEIFS you'd need to create two additional columns with the entry/exit dates/times added, e. In the worksheet shown, the formula in cell H5 is: =AVERAGE(FILTER(data,group=G5)) where data (C5:E16) and group (B5:B16) are named ranges. AVERAGEIFS evaluates all the conditions row by row and no row will meet both those conditions. I only added some of January's data and not all the months for the post. The AVERAGEIFS function in Excel gives the option to insert multiple ranges in order to find the average based on specific criteria. You require an OR condition since any one row could not be both 1 and 2. Rather than spanning dates across the columns on a single row, you should use a single date column. criteria1 is required. For example, if you want to calculate the average of only the numbers greater than zero and lesser than 100, you can use the formula and specify the two criteria. Yep! Averageif is capable of handling multiple text conditions in one column. The formula makes use of a virtual array, containing the values of column C and the output of the mmult () function. Note that, we have changed the column 1 title from Month to Month Number so as to include the numbers inside the formula. Average cells that contain errors or zeros. In this sub-method, we will calculate an average of the cell values of the Quantity column only where the cell values in the Product and Month columns are not blank. Yields the answer 6, so AVERAGEIFS (or an alternative formulation) should be able to produce an average for those 6 cells. For example, it calculates: Row 1: 100 – 90 = 10. AVERAGEIF based on multiple columns in google spreadsheet. 1. I would also avoid using whole column references where possible. The AVERAGE function calculates the average of numbers provided as arguments. We have marked both criteria with a Yellow color. Use of AVERAGEIF Function to Find VLOOKUP AVERAGE in Excel. That didn't work either. Let us see how to apply this function with multiple ranges. e. Syntax =AVERAGEIFS(average_range, criteria_range1, criteria1, [criteria_range2, criteria2],. in C2 it needs to calculate the average of F2-F6 since E2-E6 is equal to, or between 140 and 142 (Interval in cells A-B). Note that the desired values that we wish to average are present, along with a bunch of #DIV/0! errors. Calculate Average based on multiple condition in Excel. If I understood correctly, you are trying to choose dates before 4/1/14 OR after 8/30/14. Now follow the instructions at the top of that screen. The Excel AVERAGEIFS function returns the average of all numbers in a specified range based on multiple criteria. criteria_column1 – The. One is Name Box and another is Formula Box. In this video we will be learning calculating conditional average from multi column data. From the list of products, I took the unique values for a certain month. 1. Joined Dec 15, 2005 Messages 1,227 Office Version. Applying Multiple Criteria in AVERAGEIFS Function. Example 1: AVERAGEIFS with One Character Column. Range("G:G"), Sheets(wsName). Averageifs using OR function. The sum range argument in the SUMIFS function cannot have multiple columns. SUMPRODUCT is one of the most useful functions that can extract data or do complex calculations by scrutinizing all mentioned criteria along rows & columns from an array. In both the VBA and Excel examples the formula averages all of the numbers in columns C and D. AverageIFs multiple columns when meets multiple criteria in one column. Description. g. Thread starter mgirvin; Start date Dec 6, 2011; M. RangeForCriteria1: C2 to C8. Thread starter conlan; Start date Jul 23, 2014; C. . I've also tried inserting a new row below the dates (i. I have tried =Average (IF ( (A:A="Apps")* (B:B="4")* (C:C="new")+ (C:C="open. Select the columns or rows you want to compare. The AVERAGEIF Function allows you to average the sum of a range of cells that meet a certain criteria. Excel averageif with specific cells Hot Network Questions Meaning of "the field was found to be plowed as thoroughly as any young man at Oxford" in 'The Book of Dragons'For the first part, you can try adding the booleans for your two conditions to see if they both are true: =AVERAGE (IF ( (A17:A71<I16)+ (A17:A71>=I17);B17:B71)) Note that this is an array-formula, so you must enter it as such (hit Ctrl + Shift + Enter when done entering the formula). I have used your code of calculating rolling average but. This formula can be easily solved with the AVERAGEIF function or the AVERAGEIFS function . But from what I have read so far in the forum, it's not the right function to get where I want to. 2. Note the lookup_value in XLOOKUP is 1 since the logical expressions in lookup_array create an array of 1s and 0s. AVERAGE takes multiple arguments in the form number1, number2, number3, etc. 08-12-2022 12:38 AM. The AVERAGEIFS function works like AVERAGEIF, except it is designed to apply multiple criteria. Let us see how to apply this function with multiple ranges. Another issueis that some rows not all of the columns in reaction [Hit 1]:reaction [Hit 5] are populated and the blanks should not be included in the average. 1. I work in a call center, and I'm working with a quality report trying to generate an average for each supervisor. This way, other members can see what has already been done in regards to a. are in a group of functions that do not support 3D. I need the formula to find the value of "BF3" in every sheet from A3 down to A100 but i need the average value. So how would I be able to take out the average of a table using dynamic columns and rows. AverageIfs Multiple Criteria In Columns Feb 5, 2014. AVERAGE using multiple criteria from. After this, you. If you apply this method on a series object, it returns a scalar value, which is the mean value of all the observations in the pandas DataFrame. It also supports the specification of multiple columns to compute. I'm wondering if there is a way to nest a vlookup or index match or anything like that in the AVERAGEIFS that read the criteria column heading and criteria in a cell (or 2 if they need to be separated) to be added to the AVERAGEIFS. The formula I have now works fine but as I add more columns and the data table that may be out of order it would be much better if I was able to incorporate a lookup or match into the. Here's a formula for that:Calculating Average by multiple columns. Select a blank cell, enter formula =AVERAGE (IF (MOD (COLUMN (C2:G2)-COLUMN (C2),2)=0,IF (C2:G2,C2:G2))) into the Formula Bar, and then press the Ctrl + Shift + Enter keys simultaneously. Excel begin AverageIF function. mgirvin Well-known Member. Returns the average (arithmetic mean) of all cells that meet multiple criteria. Breaking my head over this, time to look for help :(I have a sheet with raw data, as illustrated below. The example is the column is Apples and the next columns are Red Apples, then yellow apples and the Apples column is taking an. Below is one more solution for the sameI want to average data in those columns if specific multiple criteria is met in other columns. What I'm trying to do is create a new spreadsheet that will give me an average of multiple weeks for specific individuals. The AVERAGEIFS function will take these criteria and ignore the entire row if there is a blank. AVERAGEIF Function. AVERAGEIF with multiple criteria: AVERAGEIFS. Alternatively, you can also use the “Formula bar” box located on the top of columns after selecting the cell; and insert. Sorted by: 1. I cannot perform this function using AVERAGEIFS since the ranges are not the same size, spanning multiple columns. AverageIfs(Sheets(modelName). In my small example below with 3. AVERAGEIFS(average_column, criteria_column1, criterion1, criteria_column2, criterion 2) average_column - The data column to average. Ask questions for further explanation. I want to know the average of all Cat that are in the UK only, which would be 3. I think the best way to do this is to just calculate the average the old fashioned way:. Step 2: Next, we will enter the Excel AVERAGEIF formula in the empty cell B10. Sorted by: 1. The criteria in the form of a number, expression, cell reference, or text that defines which cells are. From the remarks for the AVERAGEIFS function: Each cell in average_range is used in the average calculation only if all of the corresponding criteria specified are true for that cell. You have given us a calculated range selection as C2:K22 however, the range on your attached file is C2:N22. Type or copy this formula: =AVERAGE (A1:B7,C2:D5,E2:F6) Using commas to separate the non-contiguous ranges in the formula, you can add as many ranges as you need. Sample usage. 3. 0. This function can be used to know the average balance in the inactive bank accounts with an updated KYC. AverageIf(Range("F5:F30"), "Savings",. 3 B 213. Excel: How to Use AVERAGEIFS with Multiple Ranges (different columns) Hot Network Questions What is the earliest known historical reference to Tutankhamun?2. Combining the averageifs function I think does not work with "or" criteria, so I tried this [but it's not working]. Description. The AVERAGEIF function in Google Sheets has the following syntax: =AVERAGEIF(criteria_range, criterion,[average_range]) Let us break down its arguments. To average numbers based on multiple criteria, you can use the AVERAGEIFS function. In our following & new dataset, the sales of computer devices of different brands are presently based on the months. AverageIFs multiple columns when meets multiple criteria in one column. [like excel =AVERAGEIFS(average_range, criteria_range1, criteria1,. This guide will demonstrate how to calculate the average with multiple criteria in Excel. The AVERAGEIFS function is a built-in function in Excel that is categorized as a Statistical Function. In the example shown, the formula in cell F5 is: = AVERAGEIFS ( price, group,"<>") Where price (C5:C16) and group (D5:D16) are named ranges. I need to find get the percentage of the last column the "MS DRG CMS Geometric Mean LOS" monthly. 0. 9,047 6 15 36. The formula I've tried is: =AVERAGEIF (B7:B131,LARGE (B7:B131, {1,2,3}),G7:G131) The problem is it does not average the three, but rather it only displays the column G equivalent to the largest number in column B. Sample Usage. For example, the following formula with return the sum of all values in cells C2:C9 that are greater than or equal to 200 and less than or equal to 300. I can create the AVERAGEIF on each page to get the price average for each product types: =AVERAGEIF (range of product types;"name of the product type. For example, in column A I have the year, in column B I have the month, and in column C I have the values. How do i get an average of a column, with multiple conditions herof an OR condition. Using a Table (or excluding the header row), avoids that difficulty. I used the AVERAGEIFS command but I recieve a message that "excel the formula you typed contains an error". =SUM (ROW (A1:A4)) and press CTRL+SHIFT+ENTER from within the formula bar to convert this to an array formula. 0. . . Similarly, the function can. Say, you want to average the profits for the products whose sales quantity is greater than or equal to 100 and profit is greater than or equal to 50,000. Please help with a formula. Here is the same formula with an adjusted range to C2:N22. Concept is below. 1. Just keep in mind that parameter orders are slightly different from AVERAGEIF. Alternatively have a look at the AGGREGATE function, which can be used as an AVERAGE function (function #1) but with options to ignore certain errors. To be honest, if you're only going to have 1, 2, 3 or 4 in that column, then you could easily use: =AVERAGEIF(F4:F39,">=2",D4. I discovered the QUERY function and 'Google Visualization API Query Language'. averageifs w/ multiple average ranges in different columns. AVERAGE using multiple criteria from multiple columns. e. For example, we are given the total cost of preparation of three items. AVERAGEIF Function. Criteria Required. If not included, `criteria_column` is used for the average instead. For example, you may want to find the average of a column only for specific regions or months. 0. For example, one formula that is in use: =AVERAGEIFS (K:K,C:C, ">=01/01/2021", C:C, "<=1/31/2021") This formula works exactly the way I want, for the data specifically only in column K. What are multiple condition averages? They are averages based on a column of numbers that include rows that meet one or more criteria. Columns G & I have text values and Column K is a number value. g. i have tried multiple ways, including this one: Avg = List. If I do a. 365; Platform. . Next, C5:C14 is the criteri_range1 argument which refers to the Section column and the C17 is the criteria1. Firstly, select your entire dataset and press the keyboard shortcut. I need to calculate an average when two criteria are met, but these criteria are in two separate columns. AVERAGEIFS needs all ranges to be the same size (including the range to average) so if you want to average multiple columns based on multiple criteria in single columns then it won't be possible to use AVERAGEIFS - try using an "array formula" like this: The issue arises when there are multiple columns with same group as Averageif takes the first column only. The average function evaluates the zero but ignores the blank cell and the. Step 3: Enter Formula for Calculated Average Field. 3. Add another pair of parameters, one which gives the range of the names and another which gives the. Formula. AverageIFs multiple columns when meets multiple criteria in one column. Specifying Multiple Range. 1 Using AVERAGE and AVERAGEIF Functions. I have used a small range for my sample below, but only make it big enough to be sure to cover your data or the calculation overhead will be significant. We can add as many criteria as needed to determine our final results. While the original AVERAGEIF function was designed to let you apply a criterion to the range of numbers you want to sum, much of the time you’ll need to apply one or more criteria to other columns. 1. 2. Enter the following formula in S2: =--(R2>0)Average for Multiple Criteria. g. In this video show you how to calculate the average values across multiple columns with a filterin. So for example in the sample above, how can I take out the average of "A" and "B" and "Z" and "L", such that I can change A to B and the answer changes. Specify the range to check against the 1st condition (B3:B15 - items). Name Prior. I will show you how to average specific numbers in. Then select the merged cells. To achieve what you describe, you can use this array formula, which must be confirmed with Ctrl - Shift - Enter. Select the range you will average all vlookup findings, and click Kutools > Content > Advanced Combine Rows. Joined Jul 23, 2014 Messages 2. AverageIf (Columns (1), _ DateValue ("10/1/2012"), _ Columns (2)) MsgBox av End Sub. The syntax for the AVERAGEIF function is: What I want to do is have that formula reference the heading and then lookup the appropriate column in the data table to apply the averageif criteria to. Range 3}, {Butler - PROJECT MASTER -… Help with. I've tried =AVERAGE(IF(D2:N28=P16,E2:N28)) but it only seems to average the first column in the range of columns that contain numbers to average. Use this array formula: =AVERAGE (IF ( (ISNUMBER (MATCH (B2:B10, {"Emp1","Emp2","Emp3"},0)))*. My dataset is about 15,000 rows, and the values I want to average (in a separate list) amount to around 2,000 values - using something like AVERAGEIFs would suffice, but it's going to take me an age - I'm wondering if there's a good way around. kckliodna; Aug 25, 2023; Excel Questions; Replies 3 Views 452. Averageifs with Or. Green 10. Issue - How can I find the daily average of Group A for the given dates, given that Group A are in two columns (they can't be combined as there are multiple sub groups) Now, you can see that in the AVERAGEIFS function, cell range D5:F13 is selected as average_range.