LinkBack URL
About LinkBacks
Hello. If I have a list of customers with years for example customer 1, year 1-3....customer 2, year 1-2....etc. How can I average amounts for each customer?
Example: A1:A3= Customer 1 A1:A3= 1, 2, 3 (years)
Hello. If I have a list of customers with years for example customer 1, year 1-3....customer 2, year 1-2....etc. How can I average amounts for each customer?
Example: A1:A3= Customer 1 A1:A3= 1, 2, 3 (years)
Formula:
Please Login or Register to view this content.
Hahaha. That works but I need the average for each customer and not all customers have the same # of years and there are 1000's of customers. I need a conditional statement I think.
Try "=AVERAGEIF"
http://office.microsoft.com/en-us/ex...in=HP010342656
I've posted an example. I need a formula that will give me those average values in 1000's of rows.
In F5 and copy down.
=IF(C6<>C5,AVERAGEIF($C$5:$C$14,C5,$E$5:$E$14),"")
Customer Year #
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
Another method.
@alkey. That worked perfectly. Thanks.
Last edited by ammartino44; 09-16-2014 at 05:45 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks