New Contributor

# Easier formula

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

# RE: Easier formula

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

# RE: Easier formula

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