Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Can Excel count only positive numbers in a column?

Status
Not open for further replies.

FYRGUY

Technical User
Nov 27, 2005
42
US
Can anyone give me the formula for Excel to count only positive numbers in a column?

I have a sheet that will have mostly positive numbers in a particular column, however, I do not want it to subtract (or add) any that are a negitive number because I am sending the negitive numbers somewhere else. I know that probably sounds crazy, but I am hoping there is a formula for such a thing.....

Thanks for any help.

Chris
 
=countif(A:A,">0")
to "count only positive numbers in a column".

[tt]_____
[blue]-John[/blue][/tt]
[tab][red]The plural of anecdote is not data[/red]

Help us help you. Please read FAQ181-2886 before posting.
 
My apoligies......
I need it to "add" the positive numbers. sorry.

Is there a "addif"?

Thank you
Chris
 
Ah.

=SumIf(A1:A5,">0")

[tt]_____
[blue]-John[/blue][/tt]
[tab][red]The plural of anecdote is not data[/red]

Help us help you. Please read FAQ181-2886 before posting.
 
Thank you so much.

I am sitting here laughing about my "addif". Once I read your first reply I tried the "SUMIF" (which only makes since!!)and it worked great. Thank you very much.

I do not know where the "addif" came from.......

Chris
 
No problem. Glad to help.

[tt]_____
[blue]-John[/blue][/tt]
[tab][red]The plural of anecdote is not data[/red]

Help us help you. Please read FAQ181-2886 before posting.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top