this formula is returning VALUE#! error, the formula works if data is filled
in through cells 500, but if there are blank cells in the range I get this
error.

I'm trying to find out the average in column R, if column I is "ggo025" and
column R is not "". Please help, thanks.



=SUMPRODUCT((I2:I500="ggo025")*(R2:R500<"")*(R2:R 500))/SUMPRODUCT((I2:I500="ggo025")*(R2:R500<""))