As you've described it, you've got a circular reference in E6, but if you
put the formula in D6 (for example) you can use
=IF(SUM(OFFSET(Sheet1!E$6,0,3*(ROW()-6),1,3))
0,SUM(OFFSET(Sheet1!E$6,0,3*(ROW()-6),1,3)),"")
and copy that down.
--
David Biddulph

"Mtabaruka" wrote in message
...
I'm copying a formula that gets its values from a different worksheet and
the
values are not from a serielised range. How can I write it so that the
values
automatically pick up which cells to refer to? i.e
if CELL E6 has formula:
IF(SUM('Sheet1'!E$6:G$6) 0,SUM('Sheet1'!E$6:G$6),"")

CELL E7 should have :
=IF(SUM('Sheet1'!H$6:J$6) 0,SUM('Sheet1'!H$6:J$6),"")

CELL E8 should have :
=IF(SUM('Sheet1'!K$6:M$6) 0,SUM('Sheet1'!K$6:M$6),"")

so thats E:G, H:J, K:M etc



--
Wether you think you can or you think you cant , you are right ... anon