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