Hey there, I’m new. I am trying to average the total minutes of first N -- in this case, 3 -- movies watched by a customer. Please see my sheet (remove spaces in link):
docs.google.com /spreadsheets /d/1oTwnB5u7y4KqAwamvjsEats3JiTPpYhEkOqUvOzEkDE
In column A, you can see the extracted numbers from the minutes texts so that it will add up. Column B is where the movie titles along with their duration can be marked complete by the customer using the dropdown in column C. The formula, found in cell E14, I’ve used to average the said minutes is:
=SUMPRODUCT((MOD(ROW(A2:A)-ROW(A2),2)=0)*(C2:C="Complete")*(AVERAGE(OFFSET(A2:A,0,0,3))))
However, I received an error saying the “AVERAGE caused a divide by zero error.”

Appreciate any help,
Jock