So I have some data that I would like to have average only if that data was entered in the same month and year as specified in another cell. Does anyone know how to do this? What I have tried so far is
RenewalMonths is a dynamic range where each cell in the range shows the month of the date in that row.
Please Login or Register to view this content.
RenewalYears is the same but for the years.
RenewalOverallStuff is a dynamic range where I would need to average the data that meets the criteria.
Last edited by manofcheese; 06-04-2014 at 06:33 PM.
AND doesn't work the way you would think in an array formula..
Try
=AVERAGE(IF(MONTH(G2)=RenewalMonths,IF(YEAR(G2)=RenewalYears,RenewalOverallStuff,"")))
or
=AVERAGE(IF((MONTH(G2)=RenewalMonths)*(YEAR(G2)=RenewalYears),RenewalOverallStuff,""))
Both entered with CTRL + SHIFT + ENTER
You could also try:
as a non-array formulaFormula:
Please Login or Register to view this content.
Please add reputation by clicking on the * if I have helped.
Please mark the thread SOLVED if your issue has been resolved.
Thanks, Glenn.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks