I have a formula in cell B7 being =IF(SUM(DataInput!M2*1)>0,DataInput!M2+0,"")), now I want to copy this formula across a range of columns but increasing the cell references by 4 each column across for example cell C7 should by =IF(SUM(DataInput!Q2*1)>0,DataInput!Q2+0,"") . As a side issue the "*1" and "+0" part of the equation was needed for excel to recognise the results as a number