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...
is there a way to count for blanks so "jan 1900" doesnt get counted? also not sure what the first line is representing? also the formula will be calculated as data is being inputted so there will be blank cells, so the range can vary.
not sure if there is a way to account for that
@hansvogelaar are you maybe able to assist me with correcting this ?
=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 is the formula I used.
=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 is the formula I used.
