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
My "Return Column is using
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?