Question attached
Answer :
There is no such formular
Step-by-step explanation:
there is no such Formula I'm the options given. However the total product units sold by the sales representative for the period can be calculated in the excel sheet by adding up the cells with the units sold(cells F179,F180... to F186) and inserting the formula in the cell under total units sold by sales representative. So any change of figures in the cells added would reflect in the total units cell E176, if there is an additional figure for units sold in another cell, we could add this cell to formula in E176