Average prices etc

Hi

I have a spreadsheet witth customers, month, Product, price and weight.

I want to make
price pr kilo
average price per kilo per Product
average price per kilo per Product for each customer

Is it an easy way, or do I have to make pivot ?

See my attachment

I also want a chart that shows the average price trends per product per month for the customers - To see if some of them have strange fluctuations

Thanx -

Please Login or Register  to view this content.

What`s the "--" and whats the last Expression after the "/"

Could you please explain the code?

-- is to convert logic into numerical value 1 & 0.
Formula before / gives the sum and formula after / gives the numbers .when divided it gives average.
If it is ok mark the thread solved.