Hiii,
I have 2074 customers with orders and amount, what I need, I want to know average order per person with average amount.
for example:
John 3 orders $10
Mary 5 orders $5
Sally 10 orders $10
Now I need the total average. So
(3 + 5 + 10)/3 = 6 orders
($10 + $5 + $10)/ 3 = $8.3
you can use an averageIF()
and a countif()
load a sample sheet and we can add
OR
you can simply apply a pivot table and get the average and counts for everyone
Wayne
if my assistance has helped, and only if you wish to , there is an "* Add Reputation" on the left hand side - you can add to my reputation here
If you have a solution to your thread - Please mark your thread solved do the following: >
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
Since this is a formula problem, might be easier if If you upload your sheet to google sheets and use the add-ons feature and add Formula Helper. I'm using it myself. It looks for complicated formulas and helps you solve it.. Regarding your question I'll be able to get to it in 10 minutes.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks