| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I count how many positive and negative numbers in a couumn
I need to count how many entries in a coumn and then how many of the numbers
are positive and how many negative. I know this is 3 cells, I want it to say 8 winners and 3 losers 11 total. I know how to do the count for the total number, but how do I get the winners and losers? -- Thanks Very Much! Art Nittskoff |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I count how many positive and negative numbers in a couumn
countif
Art Nittskoff wrote: I need to count how many entries in a coumn and then how many of the numbers are positive and how many negative. I know this is 3 cells, I want it to say 8 winners and 3 losers 11 total. I know how to do the count for the total number, but how do I get the winners and losers? -- Thanks Very Much! Art Nittskoff |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I count how many positive and negative numbers in a couumn
Count the positives this way:
=COUNTIF(A1:A100) and the negatives this way: =COUNTIF(A1:A10<0) Alternatively, you could add a helper column in which you run the following formula down the length of the column: =IF(A1<0,"Loser","Winner") and then use countif to count the number of "Loser" and "Winner" identifications. Adjust the range and cell references above to suit your needs. Dave -- Brevity is the soul of wit. "Art Nittskoff" wrote: I need to count how many entries in a coumn and then how many of the numbers are positive and how many negative. I know this is 3 cells, I want it to say 8 winners and 3 losers 11 total. I know how to do the count for the total number, but how do I get the winners and losers? -- Thanks Very Much! Art Nittskoff |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I count how many positive and negative numbers in a couumn
Hi Art,
Try something like this. ="There are "&COUNTA(A1:A6)&" total, "&COUNTIF(A1:A6,"<1")&" loosers, "&COUNTIF(A1:A6,"0")&" winners." HTH Regards, Howard "Art Nittskoff" wrote in message ... I need to count how many entries in a coumn and then how many of the numbers are positive and how many negative. I know this is 3 cells, I want it to say 8 winners and 3 losers 11 total. I know how to do the count for the total number, but how do I get the winners and losers? -- Thanks Very Much! Art Nittskoff |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to switch negative numbers to positive numbers in Excel ? | Excel Worksheet Functions | |||
| Add sequences of positive then negative numbers | Excel Discussion (Misc queries) | |||
| Compare Negative & Positive Numbers | New Users to Excel | |||
| how do I rank negative and positive numbers? | Excel Worksheet Functions | |||
| How can I change positive numbers to negative, i.e. change 50 to - | Excel Discussion (Misc queries) | |||
Linear Mode
