Home |
Search |
Today's Posts |
#1
|
|||
|
|||
average positive numbers
Simple question...I'm trying to obtain an average but only want to include
those cells with positive numbers in the average. Any ideas? |
#2
|
|||
|
|||
One way (array-entered: CTRL-SHIFT-ENTER or CMD-RETURN):
=AVERAGE(IF(A1:A1000,A1:A100)) In article , "Susannah" wrote: Simple question...I'm trying to obtain an average but only want to include those cells with positive numbers in the average. Any ideas? |
#3
|
|||
|
|||
this is an ARRAY formula so must be entered/edited with ctrl+shift+enter
=AVERAGE(IF(H2:H1010,H2:H10)) -- Don Guillett SalesAid Software "Susannah" wrote in message ... Simple question...I'm trying to obtain an average but only want to include those cells with positive numbers in the average. Any ideas? |
#4
|
|||
|
|||
On Thu, 10 Feb 2005 17:05:01 -0800, "Susannah"
wrote: Simple question...I'm trying to obtain an average but only want to include those cells with positive numbers in the average. Any ideas? =SUMIF(rng,"0")/COUNTIF(rng,"0") The above does not include "0" values. --ron |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Erf (the error function) for both negative and positive numbers | Excel Discussion (Misc queries) | |||
Average Non-Contiguous numbers | Excel Worksheet Functions | |||
Negative numbers turn positive automatically on data entry | Excel Discussion (Misc queries) | |||
How do I drop the lowest 2 numbers and then average? | Excel Worksheet Functions | |||
adding only positive numbers | Excel Discussion (Misc queries) |