Need Excel Formula

[raajnabriz]

Need Excel Formula to get average upto a cell that is populated when the number is greater than 0. The formula to be placed below the Totals in Cell B17, Thanks.

 

[Tom.Jones]

HI,

try AVERAGEIF or AVERAGEIFS

 

[raajnabriz]

HI,

try AVERAGEIF or AVERAGEIFS

Hi,
Can you please give a demo with the above 2 formulas.

 

[Peter_SSs]

=AVERAGEIF(B2:B14,">0")

 

[raajnabriz]

=AVERAGEIF(B2:B14,">0")

Thank you for the Formula, it works.

 

[Peter_SSs]

You're welcome. Thanks for the confirmation.

 

[HighAndWilder]

Need Excel Formula to get average upto a cell that is populated when the number is greater than 0. The formula to be placed below the Totals in Cell B17, Thanks.
View attachment 115547

There is the AVERAGEIF function that you can use.

=AVERAGEIF(B3:B14,">0",B3:B14)

 

[Peter_SSs]

There is the AVERAGEIF function that you can use.

=AVERAGEIF(B3:B14,">0",B3:B14)

That function is what was used in the post #4 suggestion (& the range does not need to be repeated in this circumstance)

 

[HighAndWilder]

That function is what was used in the post #4 suggestion (& the range does not need to be repeated in this circumstance)

I didn't get the message that I normally get that others had already replied.

 

[Peter_SSs]

I didn't get the message that I normally get that others had already replied.

Fair enough.