Average

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Jordan - 06 Nov 2006 21:19 GMT

Can anyone tell me what formula to use to average something like this:

$50K - 20%
$40K - 20%
$30K - 60%

Where $50k has 20% of the weight, etc. Any help will be greatly appreciated.

Reply to this Message

Dave F - 06 Nov 2006 21:24 GMT

=(50,000*.2+40,000*.2+30,000*.6)/3

Dave

Signature

Brevity is the soul of wit.

> Can anyone tell me what formula to use to average something like this:
>
[quoted text clipped - 3 lines]
>
> Where $50k has 20% of the weight, etc. Any help will be greatly appreciated.

Reply to this Message

S Davis - 06 Nov 2006 21:29 GMT

This got a loud *hoot* out of me here in the office. Something about
the misposted reply + your signature :) Thanks for the laugh

> =(50,000*.2+40,000*.2+30,000*.6)/3
>
[quoted text clipped - 9 lines]
> >
> > Where $50k has 20% of the weight, etc. Any help will be greatly appreciated.

Reply to this Message

Duke Carey - 06 Nov 2006 21:28 GMT

With the dollar values in A1:A3 and the percentages in B1:B3 use

=sumproduct(A1:A3,B1:B3)

> Can anyone tell me what formula to use to average something like this:
>
[quoted text clipped - 3 lines]
>
> Where $50k has 20% of the weight, etc. Any help will be greatly appreciated.

Reply to this Message