Sales Revenue computation

[IB40]

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

 

[maxflia10]

This should give you an idea, I think this is sort of what you want

Book1
	A	B	C	D
1	customer	item	cost
2	a	1	10	32
3	b	1	12
4	a	1	12
5	b	1	10
6	c	1	11
7	a	1	10
Sheet1

But then thinking is not my forte'

 

[tgrimes]

You may want to consider using a pivot table. Use the wizard and you should have your solution in a matter of minutes.

 

[IB40]

Thank you for your answers!