Is there a SIMPLE way or a macro to compute the YEARLY REVENUE per customer, when the same item is sold to a particular customer at different prices?
Example: Customer in A2 bought Item #1 for $10, $12, and $15 through the year.
The spreadsheet is set up the following way:
A2:A200 = customers
B2:B200 = yearly revenue per customer
C2 = yearly qty ordered by customer A2 for item #1
D2 = yearly qty ordered by customer A2 for item #2
C3 = yearly qty ordered by customer A3 for item #1
and so on. Please help. There are over 60 items.
This message was edited by IB40 on 2002-10-27 23:52
Example: Customer in A2 bought Item #1 for $10, $12, and $15 through the year.
The spreadsheet is set up the following way:
A2:A200 = customers
B2:B200 = yearly revenue per customer
C2 = yearly qty ordered by customer A2 for item #1
D2 = yearly qty ordered by customer A2 for item #2
C3 = yearly qty ordered by customer A3 for item #1
and so on. Please help. There are over 60 items.
This message was edited by IB40 on 2002-10-27 23:52