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