=SUMPRODUCT((A1:A8="2")*(B1:B8<""))
or
=SUMPRODUCT(--(A1:A8="2"),--(B1:B8<""))
--
David Biddulph

wrote in message
oups.com...
Hi all. I did try searching this group for answers, but couldn't find
an example for exactly what I'm trying to do, although I'm sure it is
quite simple (I'm and excel rookie...).

Two columns, A & B:
1 n
1 a
1
2
2 c
2
1
1 y

How do I do a count of how many rows have the "2" (text, not number)
in column A -and- have non-blank in column B (so any text value in
column B)?
So in the above case, I would want the result to be a count of 1, for
the row that had 2 c.......

Thanks!!!!!!!!!!!!