=sumproduct(array1,array2)/sum(array1)

"Seth23hare" wrote in message
...
I have a spreadsheet that I need to insert this formula into, but am not
sure
how to calculate it through excel.