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)
Can a MONTH() or YEAR() function be nested into a MINFS function? I am trying to get the min and max for a given month. The data is daily data with the date as the column header. For the monthly summary, the Month/Year is the column header. Thanks.
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
All IF functions like COUNTIF, SUMIF, AVERAGEIF, MINIF, MAXIF are not friendly with formulas inside them,
To do this, you will have to use AGGREGATE function (Assuming E2 has month, E3 has year, Column A has dates and column B has values)
=AGGREGATE(15,6,B2:B1000/((MONTH(A2:A1000)=E2)*(YEAR(A2:A1000)=E3)),1)