Copying formulas?

[john123]

I have come up with the following formula and would like to now use it on in every row. I want each row to calculate the values in THAT row. Is there an easy way to copy this formula to all rows?

I have been using copy/paste and then dragging the selected cells to match the rows but I will go insane doing that several hundred times.

Thanks,
John


=IF(COUNT(E2:AE2)>14,AVERAGE(E2:AE2),"DNQ")

[Roadie]

I don't understand your problem. You mean that if you copy the formula down, the E2:AE2 doesn't change in A3:AE3 and so on?

[john123]

That was the problem...But I figured it out!

Thanks anyway,
John