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>
 

Some videos you may like

Excel Facts

Copy formula down without changing references
If you have =SUM(F2:F49) in F50; type Alt+' in F51 to copy =SUM(F2:F49) to F51, leaving the formula in edit mode. Change SUM to COUNT.

henrik2h

Board Regular
Joined
Aug 25, 2008
Messages
139
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
139
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)
 

Watch MrExcel Video

Forum statistics

Threads
1,123,304
Messages
5,600,864
Members
414,409
Latest member
FloordAlex

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