COUNTIF formula against 2 conditions 1

[ccepaulb]

I want to calculate a weighted average of sales.
To do this I thought I'd need to write a COUNTIF fromula that counts cells that contain values greater than or less than zero.
The problem is that I can not get the formula to work. I had to write two seprate COUNTIF fromulas; one that counts the cells with values greater than zero and one that counts values less than zero.
Is there a way to write one COUNTIF fromula that says "count the cells that contain values greater than or less than zero"?

Thanks, Paul

 

[bluedragon2]

=COUNTIF(A1:A10,">0")+COUNTIF(A1:A10,"<0")



[Blue]Blue[/Blue] [Dragon]

If I wasn't Blue, I would just be a Dragon...

 

[carrr]

Or, this might come in handy for you:

http://www.j-walk.com/ss/excel/tips/tip74.htm

&quot;'Tis an ill wind that blows no minds.&quot; - Malaclypse the Younger

 

[bluedragon2]

or

=COUNTIF(A1:A3,"<>0")

[Blue]Blue[/Blue] [Dragon]

If I wasn't Blue, I would just be a Dragon...

 

[ccepaulb]

That was so easy that I did not even think of it!

Thanks, Paul