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?


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.