Multiply 2 Columns and display the result
I have an "Ordered" column and "Sell" column. I want to multiply the value in Ordered by Sell to generate an Ext Sell value in a third column.
I have tried the following formula in the Ext Sell column but I get #invalid operation
=SUM(Ordered:Ordered * Sell:Sell)
Where have I gone wrong?