I am trying to calculate the average of 5 questions if another question
responded 1 or 2, this equation keeps bringing up 0. The data is on another
worksheet in my workbook. The worksheet is called paste_data.


=AVERAGE(IF((paste_data!CL2:CL2000=1 or 2),paste_data!B2:F2000))