SUMPRODUCT discounting blank cells

[anwaee2]

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))

 

[nemmi69]

Try
=SUMPRODUCT(--(MONTH($A$6:$A$371)=MONTH(R3&1)),--(INDIRECT(R2)<=R4)*(A:A<>""))

 

[kvsrinivasamurthy]

Try

=SUMPRODUCT(--(MONTH($A$6:$A$371)=MONTH(R3&1)),--(LEN(R2)>0))

 

[anwaee2]

Thanks to all. Using nemmi69, I used this formula and it worked great. Thank you so much.

=SUMPRODUCT(--(MONTH($A$6:$A$371)=MONTH(R3&1)),--(INDIRECT(R2)<=R4)*(INDIRECT(R2)<>""))

 

[anwaee2]

Try

=SUMPRODUCT(--(MONTH($A$6:$A$371)=MONTH(R3&1)),--(LEN(R2)>0))

Sorry, I got error message: #value.

 

[kvsrinivasamurthy]

A6:A371 is range and R2 is a single cell. Instead of R2 use R6:R371. If not ok upload a image of data.