Calculating Percentages Formula for Multiple Rows?

Is there a formula for when add I raw data, the average can be calculated for multiple rows? See my screenshot:

I would want the Adherence Average column to show the average percentage of Break and Lunch for Agent Name. I did a basic AVG function for Person A's Break and Lunch to get their Adherence Average, but would it be possible for the rest of the Adherence Averages to show for the other Persons?


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!