Sum the product of two colmuns of data?

[joeblog60]

I need to sum the results of an operation using two different columns of numbers. Basically:

A1*cos(B1)+A2*cos(B2)+...A500*cos(B500)

with some constants thrown in. Is it possible to put an operation like this in the sum function and get it to work? I know I could make a new column of data with the function and sum that to get what I need, but I have to do this 300 times so I don't want to handle that much data if at all possible.

Thanks in advance!

[arthurbr]

Perhaps =sumproduct(A1:A500,cos(B1:B500))

[joeblog60]

That seems to be working, thanks for saving me four hours!

[arthurbr]

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save

[joeblog60]

OK, what if I need to find the sum of:

C1*((A1-B1)(ln(A1-B1)^2)+(A1-B1)*(ln(A1-B1)^2)) +
C2*((A1-B2)(ln(A1-B2)^2)+(A1-B2)*(ln(A1-B2)^2)) +
...
C500*((A1-B500)(ln(A1-B500)^2)+(A1-B500)*(ln(A1-B500)^2))

Is this possible? Each term has a + and a * in it.