Weighted Average Rate Code

**Nick3535** · 10-08-2010, 12:11 PM

I need help making a code that will find the Weighted Averaghe Rate and put it in Cell E6 of the Customer 1 and 2 tabs. I really am not even sure on how to start in write it. In the Customer tabs, the code would have to find the row with "Note" in Column B. Then in that row, it would need to mulitply the Account Balance by $B$6 then divide that by the Rate. After that it would have to sum all of those calculation and put it in $G$6 of each customer tab. Sorry if this is confusing. Is this code possible? I attached my workbook.

Thanks for the help
Nick

**StephenR** · 10-08-2010, 02:04 PM

Nick - could you provide your expected answer for one or both customers?

**Nick3535** · 10-08-2010, 03:02 PM

I'm sorry. I wrote that wrong. It would have to Divide the Account Balance By the $B$6 then multiply that by the Rate. The answer in Cell G6 would be 6.20% for customer 1.

Thanks
Nick