Home |
Search |
Today's Posts |
#1
|
|||
|
|||
add only positive numbers and avg in a column
I have a column, with both positive and negative numbers.
I want to know how to have Excel count the positive numbers and then devide by the total number of positve and neg. numbers. So count the number of positive numbers (say 8) then dived that by the total of cells with numbers in them (so the 8 positive plus the 5 neg. = 13 cells w/numbers.) So 8/13. = 61% thanks for any help. rich |
#2
|
|||
|
|||
Use Countif() and count() =COUNTIF(A1:A10,"0")/COUNT(A1:A10) "rich" wrote in message ... I have a column, with both positive and negative numbers. I want to know how to have Excel count the positive numbers and then devide by the total number of positve and neg. numbers. So count the number of positive numbers (say 8) then dived that by the total of cells with numbers in them (so the 8 positive plus the 5 neg. = 13 cells w/numbers.) So 8/13. = 61% thanks for any help. rich |
#3
|
|||
|
|||
Hi!
=COUNTIF(A1:A10,"0")/COUNT(A1:A10) Is zero a positive number? You're Countif will exclude zero but Count will not. Biff -----Original Message----- Use Countif() and count() =COUNTIF(A1:A10,"0")/COUNT(A1:A10) "rich" wrote in message ... I have a column, with both positive and negative numbers. I want to know how to have Excel count the positive numbers and then devide by the total number of positve and neg. numbers. So count the number of positive numbers (say 8) then dived that by the total of cells with numbers in them (so the 8 positive plus the 5 neg. = 13 cells w/numbers.) So 8/13. = 61% thanks for any help. rich . |
#4
|
|||
|
|||
P.S.
In other words, how does the poster want to handle zeros, if any? Biff -----Original Message----- Hi! =COUNTIF(A1:A10,"0")/COUNT(A1:A10) Is zero a positive number? You're Countif will exclude zero but Count will not. Biff -----Original Message----- Use Countif() and count() =COUNTIF(A1:A10,"0")/COUNT(A1:A10) "rich" wrote in message ... I have a column, with both positive and negative numbers. I want to know how to have Excel count the positive numbers and then devide by the total number of positve and neg. numbers. So count the number of positive numbers (say 8) then dived that by the total of cells with numbers in them (so the 8 positive plus the 5 neg. = 13 cells w/numbers.) So 8/13. = 61% thanks for any help. rich . . |
#5
|
|||
|
|||
there will be NO zero's. but a cell could be blank. i
dont want it counted then. thanks again. -----Original Message----- P.S. In other words, how does the poster want to handle zeros, if any? Biff -----Original Message----- Hi! =COUNTIF(A1:A10,"0")/COUNT(A1:A10) Is zero a positive number? You're Countif will exclude zero but Count will not. Biff -----Original Message----- Use Countif() and count() =COUNTIF(A1:A10,"0")/COUNT(A1:A10) "rich" wrote in message .. . I have a column, with both positive and negative numbers. I want to know how to have Excel count the positive numbers and then devide by the total number of positve and neg. numbers. So count the number of positive numbers (say 8) then dived that by the total of cells with numbers in them (so the 8 positive plus the 5 neg. = 13 cells w/numbers.) So 8/13. = 61% thanks for any help. rich . . . |
#6
|
|||
|
|||
Then Steve's formula will work just fine.
Biff -----Original Message----- there will be NO zero's. but a cell could be blank. i dont want it counted then. thanks again. -----Original Message----- P.S. In other words, how does the poster want to handle zeros, if any? Biff -----Original Message----- Hi! =COUNTIF(A1:A10,"0")/COUNT(A1:A10) Is zero a positive number? You're Countif will exclude zero but Count will not. Biff -----Original Message----- Use Countif() and count() =COUNTIF(A1:A10,"0")/COUNT(A1:A10) "rich" wrote in message . .. I have a column, with both positive and negative numbers. I want to know how to have Excel count the positive numbers and then devide by the total number of positve and neg. numbers. So count the number of positive numbers (say 8) then dived that by the total of cells with numbers in them (so the 8 positive plus the 5 neg. = 13 cells w/numbers.) So 8/13. = 61% thanks for any help. rich . . . . |
#7
|
|||
|
|||
"Biff" wrote in message ... Hi! =COUNTIF(A1:A10,"0")/COUNT(A1:A10) Is zero a positive number? As positive and negative are defined in terms of zero, it is neither. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|