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

Square and cube roots
The =SQRT(25) is a square root. For a cube root, use =125^(1/3). For a fourth root, use =625^(1/4).
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 $
 
Upvote 0
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.
 
Upvote 0
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)
 
Upvote 0

Forum statistics

Threads
1,218,909
Messages
6,145,166
Members
450,592
Latest member
Boulder127

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
Back
Top