Do you mean a #VALUE! error? If so, then it's likely that your range of
cells contains one or more text values. Maybe your range contains
formula blanks. Try the following syntax instead...

=SUMPRODUCT(--(MOD(ROW(E7:E190)-ROW(E7),4)=0),E7:E190)

....which ignores text values, including formula blanks.

Hope this helps!

In article ,
Brent wrote:

I use this formula to sum the values in every fourth cell in colums
=SUMPRODUCT((MOD(ROW(E7:E190),4)=3)*(E7:E190)). This works in about half of
the colums, but returns the error #DIV/0! in the other colums. I do not get
why I get the error only some of the time.

What causes this and how do I correct it?

Thanks