Not sure my previous post got through..(with detailed explanation)

Use
=SUMPRODUCT((H111:H25655),(MOD(ROW(H111:H25655),10 3)=8))


"stew" wrote:


i HAVE A COLUMN OF EXPENCES THAT IS SUB TOTALLED EVERY 103 ROW USING
=SUM(H113:H213),=SUM(H216:H316) etc,etc,tec
These sub totals are picked up by
=SUMPRODUCT((H111:H25655)*(MOD(ROW(H111:H25655),10 3)=8))


All works perfectley until I put a Hyperlink cell in any H ROW AFTER 111.
then a #VALUE! COME S UP IN THE
=SUMPRODUCT((H111:H25655)*(MOD(ROW(H111:H25655),10 3)=8)) BOX. ALLTHE SUB
TOTALS ARE FINE AND READ PERFECTLY.

My understanding was that
=SUMPRODUCT((H111:H25655)*(MOD(ROW(H111:H25655),10 3)=8)) only add from the
row numbers that divide by 103 and give the remainder of 8 so why is it
giving this #VALUE! sYMBOL when all the sub totals are reading correctly

If i put a Hyperlink in rows up to 111 then this error does not occur
Help

Stew