Equation Help I have two columns, A and B. Column A has numbers on various rows

Question

Equation Help

I have two columns, A and B. Column A has numbers on various rows as shown. Column B has numbers on all rows. I would like to determine the weighted average of the numbers in Column B that have numbers in Column A.

Weight average of specific numbers in column B = [(4*2) + (5*4) + (3*2)]/(4 + 5 + 3) = 2.83       

Row       A            B

1                            3

2             4             2

3                            5

4             5             4

5                            3

6                            3

7             3             2

Can someone please suggest how I can do this.

Thank you !!

Explanation / Answer

Hi..

Hi,

Try this ::

=SUMPRODUCT(A1:A7,B1:B7)/SUMIF(A1:A7,"<>",A1:A7)

Related Questions

Navigate

• Browse (All)
• Browse E
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.