Home |
Search |
Today's Posts |
#1
|
|||
|
|||
average by operand
I have a column with percentages that are positive and negative.
How do I calculate the Average of the postive's and an Average of the Negatives? Bruce |
#2
|
|||
|
|||
One way:
=SUMIF(B1:B100,"0")/COUNTIF(B1:B100,"0") =SUMIF(B1:B100,"<0")/COUNTIF(B1:B100,"<0") -- HTH, RD ============================================== Please keep all correspondence within the Group, so all may benefit! ============================================== "Bruce" wrote in message ... I have a column with percentages that are positive and negative. How do I calculate the Average of the postive's and an Average of the Negatives? Bruce |
#3
|
|||
|
|||
Bruce Wrote: I have a column with percentages that are positive and negative. How do I calculate the Average of the postive's and an Average of the Negatives? Bruce If the numbers are in, say, A1:A100, then your formulas a For the positives: =sumif(A1:A100,"0")/countif(A1:A100,"0") For the negatives, just simply replace "0" with "<0" -- BenjieLop ------------------------------------------------------------------------ BenjieLop's Profile: http://www.excelforum.com/member.php...o&userid=11019 View this thread: http://www.excelforum.com/showthread...hreadid=275508 |
#4
|
|||
|
|||
=AVERAGE(IF(A1:A200,A1:A20))
=AVERAGE(IF(A1:A20<0,A1:A20)) array entered using CTRL+SHIFT+ENTER, but what about the 0s, don't they fall into one of the camps -- Regards Ken....................... Microsoft MVP - Excel Sys Spec - Win XP Pro / XL 97/00/02/03 ---------------------------------------------------------------------------- It's easier to beg forgiveness than ask permission :-) ---------------------------------------------------------------------------- "Bruce" wrote in message ... I have a column with percentages that are positive and negative. How do I calculate the Average of the postive's and an Average of the Negatives? Bruce --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.788 / Virus Database: 533 - Release Date: 01/11/2004 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Average Macro | Excel Discussion (Misc queries) | |||
Average Column, but Skip Null and 0? | Excel Worksheet Functions | |||
Calculating Average Values Using Arithmetic Equations | Excel Worksheet Functions | |||
Average determination | Excel Worksheet Functions | |||
Average Formula | Excel Worksheet Functions |