Forum Discussion
List months and totals
Hello, So I want to create a formula that would reference a Column in another worksheet, the referenced Column will have a list of dates and I would like to pull out Month and year and count the numb...
jaolvera With Microsoft-365 you can achieve that.
=LET(
x,UNIQUE(EOMONTH(+A2:A8,0)),
y,COUNTIFS(A2:A8,">="&EOMONTH(x,-1)+1,A2:A8,"<="&x),
HSTACK(TEXT(x,"mmm yyyy"),y))
this worked! is there anyway that we can account for blanks in this formula, since the data rance can vary, and this formula will be in place prior to data being entered, I want to make sure it wont calculate the "blank " cell as "jan 1900"