# Need help calculating AVERAGE profit per client

#### mrdonpan

##### New Member
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 \$

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.

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)

Replies
5
Views
352
Replies
2
Views
483
Replies
16
Views
2K
Replies
8
Views
156
Replies
3
Views
145

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.

### Which adblocker are you using?

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

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