Quote:
Originally Posted by Claus Busch
Hi,
snip...
or with excel version 2007 or 2010:
=COUNTIFS(A72:A77,A81&"*",B72:B77,"closed")
Regards
Claus Busch
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2
|
Claus, thanks so much, that COUNTIFS did the trick! The SUMPRODUCT also works, but I have a wide variety of different prefix-text that I'll be searching for, so the COUNTIFS covers all cases easily!
Again, THANKS!