Need help calculating AVERAGE profit per client

mrdonpan

New Member
Joined
Jun 10, 2015
Messages
2
I need to figure out how much I make per an AVERAGE client in a given month. I can either make $5, $10, $20, $30, $45 per client. I notice that most of my profit is in the $10 & $20, but I do sometimes make $5 and once in a while $45. Below are my numbers for the month of MAY

Profit

<colgroup><col></colgroup><tbody>
</tbody>
$10
$20
$30
$5
$45
total
Clients per $

<colgroup><col></colgroup><tbody>
</tbody>
144
23
1
3
3
174
Total

<colgroup><col></colgroup><tbody>
</tbody>
$1440
$460
$30
$15
$135
$2080

<tbody>
</tbody>


<tbody>
</tbody>
 

Excel Facts

Back into an answer in Excel
Use Data, What-If Analysis, Goal Seek to find the correct input cell value to reach a desired result

henrik2h

Board Regular
Joined
Aug 25, 2008
Messages
145
Office Version
  1. 2019
Platform
  1. Windows
Eehh 2080/174?

if those are your rows, include one more row with month
use Sumif with months as your criteria, sum up Total divide this by new Sumif with month as criteria and sum Clint per $
 

mrdonpan

New Member
Joined
Jun 10, 2015
Messages
2
Eehh 2080/174?

if those are your rows, include one more row with month
use Sumif with months as your criteria, sum up Total divide this by new Sumif with month as criteria and sum Clint per $

Thank you for the feedback, but I am very novice and I'm wondering if you can write out the formula so I can plug it into the new row that you suggested.
 

henrik2h

Board Regular
Joined
Aug 25, 2008
Messages
145
Office Version
  1. 2019
Platform
  1. Windows
I am on my iPad so I suggest you click on the formula icon next to the formula field and search or Sumif, there you get an explanation.

I assume you have more than one month of data otherwise it is only one cell divided by another. The extra row is used to tell which data point belongs to which month. Create a table somewhere where you have all your months listed once and input the formula next to it. Sumif(lookup this value in my table i.e. May, look in this range for May, sum values in this range if matches May)
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,164,376
Messages
5,836,906
Members
430,461
Latest member
flavgf

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top