I have a google sheet where there are two entries for each date, but I want them to count as 1 entry so I can average the total for a month.
I have a Column "Month/Year" pulled from the Date Column using =TEXT($B2:$B,"MMM-YYYY").
My "Return Column is using =SUMIF(ARRAYFORMULA(Text($I2:$I,"MMM-YYYY")),L2,$N2:$N).
The results are perfect if I use another column; however the column I want to pull a return from is using this formula: =IF(ISBLANK(L2),"","1") which causes a return value of 0.
Is it possible to pull the return value from the column with the formula?
