Averaging Only Positive Numbers in a Range

[Premier Marketing Dept.]

Does anyone know the formula for averaging only positive numbers in a
range of cells?

I used my Excel 2003 book and I got the following formula:

{=SUM(IF(B3:B20>0,B3:B20,0))/COUNTIF(B3:B20,">0")) but it only returns
a #VALUE! to me in the cell.

Any help would be hugely appreciated.

You can post here or email me directly at (e-mail address removed). Thank
you!

 

[macropod]

Try:

=SUMIF(B3:B20,">0",B3:B20)/COUNTIF(B3:B20,">0")

Cheers

 

[Domenic]

Does anyone know the formula for averaging only positive numbers in a
range of cells?

I used my Excel 2003 book and I got the following formula:

{=SUM(IF(B3:B20>0,B3:B20,0))/COUNTIF(B3:B20,">0")) but it only returns
a #VALUE! to me in the cell.

Any help would be hugely appreciated.

You can post here or email me directly at (e-mail address removed). Thank
you!

Another way,

=AVERAGE(IF(B3:B20>0,B3:B20)), entered using ctrl + shift + enter