#### Amy

**TUG Member**

Average Annual Cost per point = ((D23x0.44)+(D28x0.38)+(D33x0.18))/3

KEY: 0.44 = home resort #1 as percentage of total points owned, 0.38 = home resort #2 as percentage of total points owned, and 0.18 = home resort #3 as percentage of total points owned. The D23, D28 and D22 refers to fields where I've identified the annual cost per point for each of those home resorts.

I cannot figure out which spreadsheet formula I should use and how to type out the formula in one of the fields. I tried the =SUMPRODUCTS formula but I obviously did not enter the formula correctly or that is the wrong formula to use. Could someone help? I am using the Google spreadsheet but I can switch to Excel if necessary.

Thanks in advance.