"Autumn Dreams" wrote:

Thank you. My apologies for not being clearer. I would then need to count
all the DEA with a corresponding "1". There are several of these to count.

Thank you.

Not a problem. This kind of thing happens all the time. Instead of the
formula I used before, use this one ...

=A1&B1

This will give you values like "1SEC" and "2DEA"

Then you can COUNT the number of cells containing the particular string you
are interested in.

B+
HALinNY