Average of two columns sum in excel

Question

I have two columns, for example: A(10,15,30) and B(2,3,No data)

And I need average: sum(a)/sum(B) but without sum any cell in A column if cell in the same row of B column is empty. I need a formula for this... Based on this example, I'm looking for a formula which will give me average 5((10+15)/(2+3)), not 11((10+15+30)/(2+3)).

Scott Craner · Accepted Answer · 2017-08-23 22:20:16Z

1

Use this:

=SUMIF(B:B,"<>",A:A)/SUM(B:B)

answered Aug 23, 2017 at 22:20

Scott Craner

153k10 gold badges52 silver badges88 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Average of two columns sum in excel

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related