Forum Discussion

busymamabee's avatar
busymamabee
Copper Contributor
Nov 10, 2022

COUNTIFS by Month Excluding Year

I'm attempting to do a COUNTIFS function based on a date range but want to exclude the year so that the date can be updated easily from one year to the next without having to redo all of the formulas...
excel
Formulas and Functions
PeterBartholomew1's avatar
PeterBartholomew1
Silver Contributor
Nov 10, 2022

busymamabee 

Being a committed Excel 365 user, I would employ something like

WorksheetFormula
= MAP(goalDate, MonthlyTotalλ(date,goals))

MonthlyTotalλ 
= LAMBDA(mnth, goals, LAMBDA(gdate, 
        SUM(IF(MONTH(date) = MONTH(gdate), goals))
  ));

... or would that constitute 'cruelty to Excel users'?

 

Resources