averageif DIV/o

[ccarruth]

Very simple problem...have two columns, first with text vales, second with numbers.
Want to average the numbers cells if first column has proper text BUT not include in average if value = 0. So only averaging >0 values with Test label in Column A. See attached.

Thanks All!

 

[Nebu]

Hi:

This is the right formula
=AVERAGEIFS(B2:B5,A2:A5,"Test",B2:B5,">0")

Thanks

 

[ccarruth]

Works great..thanks.