M
Mtabaruka
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
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