count of negative values

April 18, 2012 at 21:44:05
Specs: Windows XP
I have negative and positive values in A column and some data (Like SL, ML ) in B column and . I want to count how many SL's and ML's have negative values.

See More: count of negative values

April 19, 2012 at 02:54:04
What version of Excel are you using?
2007 & 2010 have a =COUNTIFS() function, note the trailing letter S,
which can do what you want.

Something along the lines of:


will count all the Negative values and the data SL


Report •

April 19, 2012 at 05:34:05
If you have 2003 or need a formula that will work in all versions, try this:


Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Report •
Related Solutions

Ask Question