Could someone please help me with the following excel formula. Each row in my spreadsheet contains details about a product.
I have one column 'Quantity' (Col B) and 'Profit' (Col F). I want to use a formula which takes the Quantity * Profit for each row and gives me the total.
So far I have
But this will get unwieldy very quickly. Is there a better way of writing this? I have thought of making a hidden column containing F*B for each row and summing them but would like to avoid this unnecessary column.