Quarterly Sales Metric

Medium ★★☆

Update the output cells so that each employee's average monthly sales figure is displayed considering only the months where the employee recorded at least one sale. If an employee made no sales at all, show 0. See Examples

Your solution should use cell references so it updates automatically if the input cells change values.

AVERAGEIF AVERAGE IF IFERROR

Hint

Solution Approach

Past Submissions

Signup or login to make and view submissions. Your work will be saved.

A1 expected value: *

To see an example of the expected output for a given cell, first click on any output cell. An option will then appear to show the expected value for that cell.

Your solution is tested against 3 test cases which you can toggle between. To pass, your solution should use cell references so it returns the correct output across test cases.