Shortening of a Big Formula

[nanocrazy]

I have a formula which looks like this

=((A8/B8)*C8 + (A9/B9)*C9 + (A10/B10)*C10 + (A11/B11)*C11 + (A12/B12)*C12 + (A13/B13)*C13 + (A14/B14)*C14 + (A15/B15)*C15 + (A16/B16)*C16 + (A17/B17)*C17 + (A18/B18)*C18 + (A19/B19)*C19 + (A20/B20)*C20 + (A21/B21)*C21 + (A22/B22)*C22 + (A23/B23)*C23 + (A24/B24)*C24 + (A25/B25)*C25 + (A26/B26)*C26 + (A27/B27)*C27 + (A28/B28)*C28 + (A29/B29)*C29 + (A30/B30)*C30 + (A31/B31)*C31))

This will work, but doesnt look nice if we have to go till the 500th row instead of 31.

Is there any better way of doing this in a shortened format.

[shg]

Welcome to the forum.

=SUMPRODUCT(A8:A29 * C8:C29 / B8:B29)

[daddylonglegs]

Hello nanocrazy, try this version.....

=SUMPRODUCT(A8:A31,C8:C31/B8:B31)

[nanocrazy]

Thanks Shg,Daddylnglegs...

for inviting me to the forum as well as providing me with a quick turnaround.

~Nano