Sum of the multiplication of 2 columns in excel table

Question

table:

     A               B              C       
1    Item         Unit price        QTY 
2     X             2               10    
3     Y             3               20

Now, I need in cell A10 to sum (Unit price * QTY) for all rows in the table.

I don't want to use any Total rows or to add a column to calculate this. I want to do it in a totally separate cell.

Is this possible? I tried but I'm getting an error. Here is my try:

SUM(ISSUE_ITEMS[QTY]*ISSUE_ITEMS[UNIT PRICE])

Answer 1

Try SUMPRODUCT(ISSUE_ITEMS[QTY], ISSUE_ITEMS[UNIT PRICE])