Hi!

Try this:

=SUMPRODUCT(--(ISNUMBER(SEARCH("XX",A1:A100))),--(B1:B100="XXXX"))

Biff

"Mary-Lou" wrote in message
...
I need to count two different text values within two columns.

Column A contains sentences and Column B contains various values.

Example of small sentences in Column A:
Custom XX Upgrade
Printing reports on XX
Custom YY Upgrade

Example of values in Column B:
AAAA
BBBB
BBBB

What I need to do is count groups of records, like only counting the
records
that contain "XX" anyplace witihin Column A plus have "XXXX" in Column B.

I tried countif statements with no success. Any ideas?