I have a column of numbers that is split in two, one half is multiplied by 1.37 and the other half by 2.5. I can use the sum function to get the sub totals then add these together to give the final amount.

100 * 1.37
120 * 1.37
130 * 1.37 Total = 479.5

140 * 2.5
150 * 2.5
160 * 2.5 Total = 1125

Is it possible to add the numbers together and multiply them by amounts in one formula without having to use the sub totals?
=SUM (B4:B6*1.37) sum (B7:B10*2.5)

Thanks solti