Can Excel count only positive numbers in a column?

[FYRGUY]

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

 

[AnotherHiggins]

=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.

 

[FYRGUY]

My apoligies......
I need it to "add" the positive numbers. sorry.

Is there a "addif"?

Thank you
Chris

 

[AnotherHiggins]

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.

 

[FYRGUY]

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

 

[AnotherHiggins]

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.