Hi, I’m trying to average the total minutes of the first N -- in this case, 3 in lieu of N -- movies watched by a client. Please see my sheet:
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 that the customer can mark Complete using the dropdown in column C. The formula, found in cell E14, I’ve used to average the said minutes is:
However, it returns an error saying the “AVERAGE caused a divide by zero error.”
Thanks for reading
LeAnneaux
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 that the customer can mark Complete using the dropdown in column C. The formula, found in cell E14, I’ve used to average the said minutes is:
Excel Formula:
=SUMPRODUCT((MOD(ROW(A2:A)-ROW(A2),2)=0)*(C2:C="Complete")*(AVERAGE(OFFSET(A2:A,0,0,3))))
However, it returns an error saying the “AVERAGE caused a divide by zero error.”
Thanks for reading
LeAnneaux