Sum of the multiplication of 2 columns in excel table -

table:

                   b              c        1    item         unit price        qty  2     x             2               10     3     y             3               20 

now, need in cell a10 sum (unit price * qty) rows in table.

i don't want use total rows or add column calculate this. want in totally separate cell.

is possible? tried i'm getting error. here try:

sum(issue_items[qty]*issue_items[unit price]) 

try sumproduct(issue_items[qty], issue_items[unit price])