On Thu, 27 Jul 2006 00:09:50 +0100, "Bob Phillips"
wrote:

1. =SUMPRODUCT((A1:A100="X")*(B1:B100={"X","(X)"}))

2. =COUNTIF(A:A,"X~*")

Thanks VERY much, Bob. Those were exactly what I needed:

1. The logical product makes sense. Interestingly, though, when I
looked up SUMPRODUCT in Excel Help and in several Excel books I
checked out of the library, none of them covered its use in this
way. So I very much appreciate your expertise.

2. So it appears that '~' is the escape character in Excel? (I
couldn't find this mentioned anywhere, either.)

--
Keith
--
Keith