Articles

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

Report •


#1
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:

=COUNTIFS(A1:A5,"<0",B1:B5,"SL")

will count all the Negative values and the data SL

MIKE

http://www.skeptic.com/


Report •

#2
April 19, 2012 at 05:34:05

If you have 2003 or need a formula that will work in all versions, try this:

=SUMPRODUCT((A1:A5<0)*(B1:B5="SL"))

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


Report •

Related Solutions


Ask Question