Conditional Average

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Does anyone know if there is a way to conditionally average a list of numbers? In other words, I have a list of numbers and I would like a one-cell formula that will average only the positive numbers in the list (in other words ignore the negative numbers and zero-values). I know how to do so through a couple of step process by creating a new list that only includes positive values and then taking that average but I would like a one-step process in my spreadsheet for simplicity. Any help would be appreciated. Many thanks.
 
Hi JW!

Try one way:
=SUMIF(A1:A9,">0")/COUNTIF(A1:A9,">0")

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
JW said:
Does anyone know if there is a way to conditionally average a list
Click to expand...
of numbers? In other words, I have a list of numbers and I would like
a one-cell formula that will average only the positive numbers in the
list (in other words ignore the negative numbers and zero-values). I
know how to do so through a couple of step process by creating a new
list that only includes positive values and then taking that average
but I would like a one-step process in my spreadsheet for simplicity.
Any help would be appreciated. Many thanks.
 
Norman - thank you - that worked perfectly for me. Thanks again

----- Norman Harker wrote: ----

Hi JW

Try one way
=SUMIF(A1:A9,">0")/COUNTIF(A1:A9,">0"

--
Regard
Norman Harker MVP (Excel
Sydney, Australi
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments
available free to good homes
JW said:
Does anyone know if there is a way to conditionally average a lis
Click to expand...
of numbers? In other words, I have a list of numbers and I would lik
a one-cell formula that will average only the positive numbers in th
list (in other words ignore the negative numbers and zero-values).
know how to do so through a couple of step process by creating a ne
list that only includes positive values and then taking that averag
but I would like a one-step process in my spreadsheet for simplicity
Any help would be appreciated. Many thanks
 
Back
Top