I'm trying to use an array formula to calculate the weighted average.

Gross
A:10
B:20
C:30
D:1000
----------
Total:1060

Rates
A: 15%
B: 10%
C: 30%
D: 85%

How do I use an array forumula to calculate the weighted average rate
based on gross numbers? For example, (10/1060)*15%+(20/1060)*10% and
so on?

Any help is appreciated.


--
name
------------------------------------------------------------------------
name's Profile: http://www.excelforum.com/member.php...o&userid=34115
View this thread: http://www.excelforum.com/showthread...hreadid=545146