Hi,

I am using vba in excel to populate a worksheet with appropriate formulas to a given task.

The formula i am trying to input is as follows:

IF(COUNTIF(OFFSET(T1,1,0):OFFSET(T3,-1,0),">0")=0,0,SUM(OFFSET(T1,1,0):OFFSET(T3,-1,0))/COUNTIF(OFFSET(T1,1,0):OFFSET(T3,-1,0),">0"))

Also, i really "dred" inputing formulas from vba .........is there an easy to input formulas into the sheet using vba?