This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Hey guys,
I am creating a spreadsheet in which I need to average some stats if they are in the current month. The formula is this: =AVERAGEIFS(A:A,J:J,"=Survey",B:B,">42248")
So, what it currently does is to average column A if the corresponding line in column J says "Survey", and the date in column B is greater than "42248" (September 1st).
I want it to do this without me having to change the numerical date (42248) each month. What I have so far is: =AVERAGEIFS(A:A,J:J,"=Survey",B:B,">(EOMONTH(TODAY(),-1)+1)")
The problem is that it comes back as either 0 or #DIV/0!
Can anybody help point out the sytax error? I have been toying with it for a while and can't quite figure it out.
Thank you.
- Zokah
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
Answer accepted by question author
Change the formula to
=AVERAGEIFS(A:A,J:J,"=Survey",B:B,">"&EOMONTH(TODAY(),-1)+1)
Hey HansV!
That was exactly it. Thank you!