How to calculate: sumproduct / db??
In a database I have:
column A: name of fruit
column B: number of boxes
column C: price of one box
column D: number of pieces fruit in a box
column E: price per piece of the fruit
I would like to know how to calculate the total value of one sort of fruit.
So, the result must be for "apple" the sum of (columnB * columnC)+(columnD *
columnE). Should I use the db-functions / sumproduct? Any help / suggestion
would be highly appriciated.
|