Formula to sum every 4th cell returns #DIV/0! error in some co
In that case, try the following formula...
=SUM(IF(MOD(ROW(E7:E190)-ROW(E7),4)=0,IF(ISNUMBER(E7:E190),E7:E190)))
....confirmed with CONTROL+SHIFT+ENTER, not just ENTER.
Hope this helps!
In article ,
Brent wrote:
Hey Tom,
Yes, in some of the colums the cell with this formula displays #DIV/0!, in
other columns I get the desired sums. All the cells with this formula are in
the same row (row 198) and refer to data in rows 7 - 195..
Thanks for your interest and help.
--
Brent
"Tom Ogilvy" wrote:
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
|