Averaging Only Positive Numbers in a Range

  • Thread starter Thread starter Premier Marketing Dept.
  • Start date Start date
P

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!
 
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!
Click to expand...

Another way,

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