PDA

View Full Version : Solved: It's late, please help simplify this formula



grichey
06-11-2008, 07:40 PM
=((A1*B1)+(A2*B2)+(A3*B3))/C1

This is easy to write. If you want do it for 20 rows, it is tedious. :banghead:

grichey
06-11-2008, 08:57 PM
=sumproduct

Bob Phillips
06-12-2008, 12:55 AM
Standard SUMPRODUUCT to boot!

grichey
06-12-2008, 06:19 AM
haha yeah - I'd been up wayyyy too long, staring at excel for at that point 14 hours and was just having a FAIL moment.