Continue equation

M

mparker

I have an equation average equation on sheet 3 but the data is on sheet 1.
=AVERAGE(IF(paste_data!CL2:CL2000=1,paste_data!B2:B2000))

I want to continue on my data for vertically so it would be the exact same
but instead of B2:B2000 it would be C2:C2000. Is there anyway to do this
without putting in each equation into each cell. If I drag them the equation
comes out wrong.
 
J

joel

from
=AVERAGE(IF(paste_data!CL2:CL2000=1,paste_data!B2:B2000))

to
=AVERAGE(IF(paste_data!$CL$2:$CL$2000=1,paste_data!B2:B2000))
 
Top