I have this formula that works great except it also counts the blank cells too. I would like the
--(INDIRECT(R2)<=R4 part of the formula to only use the non blank cells in that range. I tried using NOT(ISBLANK(R2)) in several different ways with no results or errors. Also I tried using AND with <>"" with nothing but errors. I would appreciate any help I can get on this. Thanks in advance.
=SUMPRODUCT(--(MONTH($A$6:$A$371)=MONTH(R3&1)),--(INDIRECT(R2)<=R4))
--(INDIRECT(R2)<=R4 part of the formula to only use the non blank cells in that range. I tried using NOT(ISBLANK(R2)) in several different ways with no results or errors. Also I tried using AND with <>"" with nothing but errors. I would appreciate any help I can get on this. Thanks in advance.
=SUMPRODUCT(--(MONTH($A$6:$A$371)=MONTH(R3&1)),--(INDIRECT(R2)<=R4))