Forum Discussion
Calculating amounts between two month dates using AVERAGEIFS?
How do I use the AVERAGEIFS function to filter out any amounts between a start month and end month (e.g between October - month 10, and March - month 3)? Any amounts that have monthly dates that fall...
Hi J-Des000
Because of the OR situation your logic creates, greater than or equal to month 10 OR less than or equal to month 3, we have to capture the criteria in different formulas. And for AVERAGE, we would have to compute it from its native SUM and COUNT breakdown.
Below is an example, to stick as closely as possible to your original AVERAGEIFS formula ask, I have created a needed month column and used SUMIFS and COUNTIFS. Sadly, AVERAGEIFS couldn't handle the situation given.
I've attached the Excel file with the formulas intact for your ease of use and review.
I hope this answers your question. If yes, kindly mark this as answer.