=((A1*B1)+(A2*B2)+(A3*B3))/C1
This is easy to write. If you want do it for 20 rows, it is tedious.
=((A1*B1)+(A2*B2)+(A3*B3))/C1
This is easy to write. If you want do it for 20 rows, it is tedious.
=sumproduct
Standard SUMPRODUUCT to boot!
____________________________________________
Nihil simul inventum est et perfectum
Abusus non tollit usum
Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
James Thurber
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.