compare columns and count

[GireeshaJ]

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

 

[JBeaucaire]

Perhaps:

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

Just adjust the quoted variables to get different counts.

 

[Max]

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