What-If-Analysis

[mrodriguez0426]

Hello everyone,

First, thanks for reading this and providing help. For the most part, I try to do everything on my own so that I can learn excel, but I have hit a brick-wall. My assignment reads:

Create a summary report showing total asking and total selling price by agent. Using subtotals, you will select the criteria for your subtotal. Each time the agent name changes, you want the total (sum) of both the Asking Price and Selling Price. Make sure the outline level of your subtotal is set to two on the left top area of your screen. Make sure you format your worksheet professionally.

I believe this is the what-if-analysis, but I can't get it work the way its showing in the example in the class. I have tried to watch videos, but I can't seem to get it to work. Can someone please help me? The information is on the sheet named "sorted data". The spreadsheet is here: https://www.dropbox.com/s/38ua6avkbb18ysq/Rodriguez_M_Week3_Lab.xlsx?dl=0

Thank you,
Miguel