CODEWITHSUNDEEP
excel
Michael T Johnson
Michael T Johnson

Reputation: 689

Applying a weight to two numbers in excel

I have 2 numbers. One is a projected number and the other is a current number. I would like to average them both but apply a lesser weight to the projected number. How does that work is excel?

Upvotes: 0

Views: 110

Answers (1)

learnAsWeGo
learnAsWeGo

Reputation: 2282

Weighted average formula: 

 =SUMPRODUCT(B4:D4,B3:D3)/SUM(B4:D4)

Upvotes: 3

Related Questions