Need help calculating AVERAGE profit per client

[mrdonpan]

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>

 

[henrik2h]

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]

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]

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)