View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Tom Ogilvy
 
Posts: n/a
Default Formula to sum every 4th cell returns #DIV/0! error in some column

do the columns have cells returing a #DIV/0 error?

--
Regards,
Tom Ogilvy


"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
--
Brent