title: Calculating Costs Based on Dropdown List
body: <p>I have an excel file that has 2 sheets. 1 for tracking services rendered and another with a list of customers and their fees per service.</p>
  <p><strong>Tracking Sheet</strong>  <a href="https://i.stack.imgur.com/Bq9F6.jpg" rel="nofollow noreferrer">See Tracking Sheet Example</a><br>
  For each service, we manually enter a number for how many times the service was rendered. We then select the client from a drop-down list that we performed the services for.</p>
  <p><strong>Clients Sheet</strong> <a href="https://i.stack.imgur.com/hyDM6.jpg" rel="nofollow noreferrer">See Client Sheet Example</a>
  <br>
  To get the &quot;Amount Scheduled to Bill&quot; and &quot;Total Billed&quot; in the tracking sheet, we reference the client sheet with pricing. This will have a list of clients along with cost for each service.</p>
  <p>Let’s say that these are the 2 formulas that will be used to calculate the following on the tracking sheet (can probably be better and if so pls share):</p>
  <p>Amount scheduled to be billed - (Used to calculate result for Amount Scheduled)<br>
  <code>=SUM(Tracking!A2*Clients!B2, Tracking!B2*Clients!C2)</code>
  <br><br>
  Total Billed - (Used to calculate result for Total Billed)<br>
  <code>=SUM(Tracking!B2* Clients!C2, Tracking!C2* Clients!D2, Tracking!D2* Clients!E2)</code></p>
  <p><strong>Question:</strong><br>
  Per row on the tracking sheet, when entering the amount of times a service was provided, how can we correlate the calculation formula per client in the drop-down to get the amount scheduled and the amount billed?</p>