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

```
=SUM((F2*B2)+(F3*B3)+(F4*B4)+(F5*B5)+(F6*B6)......)
```

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.