Hi! I'm using SUMPRODUCT at a very basic level but am running into an issue because it won't work when columns are not conseutive. I have many different files and do not want to change the order of the columns because they link to other sheets and really, it would be a pain.
Sample Data:
Col A: B, C, D, E, F
Row 2: 10, 20, 30, 40, 50
Row 3: 100, 200, 300, 400, 500
Current Formula: =SUMPRODUCT(B$2:F$2,B3:F3)
This is the formula I want (skip E): first section: B$2:D$2,F$2 / 2nd section: B$3:D$3,F$3
Any quick fixes or do I need to bit the bullet and modify my columns?
Thank you!
Sample Data:
Col A: B, C, D, E, F
Row 2: 10, 20, 30, 40, 50
Row 3: 100, 200, 300, 400, 500
Current Formula: =SUMPRODUCT(B$2:F$2,B3:F3)
This is the formula I want (skip E): first section: B$2:D$2,F$2 / 2nd section: B$3:D$3,F$3
Any quick fixes or do I need to bit the bullet and modify my columns?
Thank you!