Easier formula

%3CLINGO-SUB%20id%3D%22lingo-sub-1567138%22%20slang%3D%22en-US%22%3EEasier%20formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1567138%22%20slang%3D%22en-US%22%3E%3CP%3ELooking%20to%20see%20if%20there%20is%20a%20easier%20way%20to%20do%20long%20strings%20of%20this%20formula%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3D(G69*H69)%2B(G70*H70)%2B(G71*H71)%2B(G72*H72)%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1567138%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1567271%22%20slang%3D%22en-US%22%3ERE%3A%20Easier%20formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1567271%22%20slang%3D%22en-US%22%3EThat%20looks%20like%3A%20SUMPRODUCT(G69%3AG71%2CH69%3AH72)%3C%2FLINGO-BODY%3E
New Contributor

Looking to see if there is a easier way to do long strings of this formula

 

=(G69*H69)+(G70*H70)+(G71*H71)+(G72*H72)

2 Replies
That looks like: SUMPRODUCT(G69:G71,H69:H72)

@mtarler Thank you. My brain wasn't working I guess