Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
rich
 
Posts: n/a
Default 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   Report Post  
Steve R
 
Posts: n/a
Default


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   Report Post  
Biff
 
Posts: n/a
Default

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   Report Post  
Biff
 
Posts: n/a
Default

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   Report Post  
rich
 
Posts: n/a
Default

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   Report Post  
Biff
 
Posts: n/a
Default

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   Report Post  
Bob Phillips
 
Posts: n/a
Default


"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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT +1. The time now is 04:37 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"