Hello All,
I have a table of a list of sales to customers and I am trying to create a formulae that will give me the total value of items sold to a customer.
Table
<tbody>
</tbody>
For example I want to find the total value of things sold where Customer=Cust1 and RecordType=SI.
The price is per unit so I need the product of (Qty x Price). For this example I am expecting to get the result 6 (2*1 + 2*2).
I know how to sum over one column, for example get the number of items sold to Cust1 using sumifs, but I can find a way of get summing the product of two cells.
Any help would be great.
Thanks
I have a table of a list of sales to customers and I am trying to create a formulae that will give me the total value of items sold to a customer.
Table
Customer | Record Type | Item | Qty | Price |
Cust1 | SI | Item1 | 2 | 1 |
Cust1 | SC | Item1 | 1 | 1 |
Cust2 | SI | Item2 | 3 | 2 |
Cust2 | SI | Item1 | 5 | 1 |
Cust3 | SI | Item2 | 2 | 2 |
Cust1 | SI | Item2 | 2 | 2 |
<tbody>
</tbody>
For example I want to find the total value of things sold where Customer=Cust1 and RecordType=SI.
The price is per unit so I need the product of (Qty x Price). For this example I am expecting to get the result 6 (2*1 + 2*2).
I know how to sum over one column, for example get the number of items sold to Cust1 using sumifs, but I can find a way of get summing the product of two cells.
Any help would be great.
Thanks