Hi!

=SUMPRODUCT(--(A1:A100="C"),--(B1:B100="C1"))

Biff

"Rochelle B" wrote in message
...
I need to only count the "C" in one array, but only if there is a C1 in the
adject cell