ViperStripes
New Member
- Joined
- Sep 1, 2021
- Messages
- 10
- Office Version
- 365
- Platform
- Windows
I've got 2 columns that I want to sum each row first then multiply by the same factor for each row. e.g
So I'm trying to do (A+B)x300 for each Row then Sum the total of each row. So the answer to the above would be (£1+£1.25+£1.72+£1.96)x300 = £1779
Column C will always be the same figure all the way down. So don't even really need Col C, could just be a single cell anywhere on the sheet, would like to do away with it really.
I thought SUMPRODUCT with some tweaks or embedded other function within the brackets might work, but can't seem to work it out.
| A | B | C |
1 | £4 | -£3 | 300 |
2 | £4.25 | -£3 | 300 |
3 | £4.72 | -£3 | 300 |
4 | £4.96 | -£3 | 300 |
TOTAL: | £1,779 |
So I'm trying to do (A+B)x300 for each Row then Sum the total of each row. So the answer to the above would be (£1+£1.25+£1.72+£1.96)x300 = £1779
Column C will always be the same figure all the way down. So don't even really need Col C, could just be a single cell anywhere on the sheet, would like to do away with it really.
I thought SUMPRODUCT with some tweaks or embedded other function within the brackets might work, but can't seem to work it out.