0

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?

0

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.