count negative cells

chowderhead

New Member
Joined
May 6, 2002
Messages
1
I have a column of both positive and negative Numbers That I would like to count the number of total +numbers as well as the number of -numbers
+number formulas would be in one cell and -number formulas would be in another cell . Can anyone help me with the formulas?
 
Zero is even.... =MOD(0,2)=0


Main Entry: 2even
Pronunciation: 'E-v&n, -b&m
Function: adjective
Etymology: Middle English, from Old English efen; akin to Old High German eban even
Date: before 12th century

4 a : being any of the integers (as -2, 0, and +2) that are exactly divisible by two
 
Upvote 0

Excel Facts

Test for Multiple Conditions in IF?
Use AND(test, test, test, test) or OR(test, test, test, ...) as the logical_test argument of IF.
here are some more ... on ZERO

Edit: some material on Zero from the web

Zero

Zero is not a number. Zero is the absence of any value or number. It was the last of the decimal digits to be established in Western systems. You can count to zero by not counting.

Mathematics represents a high level of abstraction attained by the human mind. In India, mathematics has its roots in Vedic literature which is nearly 4000 years old. Between 1000 B.C. and 1000 A.D. various treatises on mathematics were authored by Indian mathematicians in which were set forth for the first time, the concept of zero, the techniques of algebra and algorithm, square root and cube root.

The concept of zero also originated in ancient India. This concept may seem to be a very ordinary one and a claim to its discovery may be viewed as queer. But if one gives a hard thought to this concept it would be seen that zero is not just a numeral. Apart from being a numeral, it is also a concept, and a fundamental one at that. It is fundamental because, terms to identify visible or perceptible objects do not require much ingenuity.

But a concept and symbol that connotes nullity represents a qualitative advancement of the human capacity of abstraction. In absence of a concept of zero there could have been only positive numerals in computation, the inclusion of zero in mathematics opened up a new dimension of negative numerals and gave a cut off point and a standard in the measurability of qualities whose extremes are as yet unknown to human beings, such as temperature.

Regards!


_________________
Yogi Anand

Edit: Deleted inactive website from hardcoded signature
This message was edited by Yogi Anand on 2003-01-19 13:16
 
Upvote 0

Forum statistics

Threads
1,214,954
Messages
6,122,461
Members
449,085
Latest member
ExcelError

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top