Hello one and all,
My first post here, arriving on recommendation of a friend. I am struggling to get excel to repeat a long simple calc without messing it up and can't figure out a robust formula to replace/simplify it.
What I am trying to do is to sum all the numbers in a column multiplied with all the numbers in a seperate column which I can do with a simple calc (shortened eg):
=(L7*F7)+(L8*F8)+(L9*F9)+(L10*F10)+(L11*F11)+(L12*F12)+(L13*F13)+(L14*F14)+(L15*F15)
This would work great and copy across apart from the fact that I am always multiplying with the same column, (shortened eg):
=(M7*F7)+(M8*F8)+(M9*F9)+(M10*F10)+(M11*F11)+(M12*F12)+(M13*F13)+(M14*F14)+(M15*F15)
When dragging the calc from the corner though it always wants to change both columns, even after correcting a few and selecting them as a group to drag from. As this is for over a hundred columns and an ever growing table at 25 rows already I do not want to be manually typing this in for each one. As such I thought I sould have a go at a proper formula but I am out of my depth and this is the closest I have come up with:
=SUM((P7*F7): (P32*F32))
That is a complete failure that Excel won't even accept
Any help with a correct formula or work around is really appreciated
My first post here, arriving on recommendation of a friend. I am struggling to get excel to repeat a long simple calc without messing it up and can't figure out a robust formula to replace/simplify it.
What I am trying to do is to sum all the numbers in a column multiplied with all the numbers in a seperate column which I can do with a simple calc (shortened eg):
=(L7*F7)+(L8*F8)+(L9*F9)+(L10*F10)+(L11*F11)+(L12*F12)+(L13*F13)+(L14*F14)+(L15*F15)
This would work great and copy across apart from the fact that I am always multiplying with the same column, (shortened eg):
=(M7*F7)+(M8*F8)+(M9*F9)+(M10*F10)+(M11*F11)+(M12*F12)+(M13*F13)+(M14*F14)+(M15*F15)
When dragging the calc from the corner though it always wants to change both columns, even after correcting a few and selecting them as a group to drag from. As this is for over a hundred columns and an ever growing table at 25 rows already I do not want to be manually typing this in for each one. As such I thought I sould have a go at a proper formula but I am out of my depth and this is the closest I have come up with:
=SUM((P7*F7): (P32*F32))
That is a complete failure that Excel won't even accept
Any help with a correct formula or work around is really appreciated
Last edited:
