Greetings,



Given the attached sample, I would like the to calculate the following:

1. Sum ‘Amounts’ (column J)--> $8,265.83
2. Sum ‘Units’ (column I) -->59.00
3. Sum of ‘Amounts’/Sum of ‘Units’ --> $8,265.83/59 =$140.10
4. Subtract 24 from total units (step #2 above) --> 59 – 24 = 35
5. Finally, multiply (step #3) by (step # 4) above -->$140.10 * 35 = $4,903.5

So, total for Provider #001 = $4,903.5

Once I obtained totals for each provider, I would like to display the grand total for all.

TIA,

Attached Images

Sample.png (25.0 KB, 21 views)