compare columns and count
 

hi,

please find requirement below...

A B
2008 Dropped
2007 rolled
2008 expired

here i want to count in 2008/2007, how many are dropped or rolled ?

please reply me with the earliest

compare columns and count
 

Perhaps:

=SUMPRODUCT(--($A$1:$A$1000="2008"),--($B$1:$B$1000="dropped"))

Just adjust the quoted variables to get different counts.

--
"Actually, I *am* a rocket scientist." -- JB

Your feedback is appreciated, click YES if this post helped you.


"GireeshaJ" wrote:

hi,

please find requirement below...

A B
2008 Dropped
2007 rolled
2008 expired

here i want to count in 2008/2007, how many are dropped or rolled ?

please reply me with the earliest

compare columns and count
 

2 examples which should quickly give you the grasp of it ..

=SUMPRODUCT((A1:A10=2008)*(B1:B10="Dropped"))
returns the count where col A = 2008,
and col B = Dropped

=SUMPRODUCT((A1:A10=2008)*(ISNUMBER(MATCH(B1:B10,{ "Dropped";"Rolled"},0))))
returns the count where col A = 2008,
and col B = either Dropped or Rolled

Splendid? Click YES below
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:23,500 Files:370 Subscribers:66
xdemechanik
---
"GireeshaJ" wrote:
A B
2008 Dropped
2007 rolled
2008 expired

here i want to count in 2008/2007, how many are dropped or rolled ?