Why not use the SUBTOTAL() function with 9 as the first argument?

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"stew" wrote in message
...

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