countif with text data in two ranges

  • Thread starter Thread starter psr
  • Start date Start date
P

psr

I have a worksheet with a dozen or so non-unique text columns. I would
like to identify counts for combinations. For example, let's say
"Timmy" is in the SalesManager column 40 times and "widget" is in the
ProductItem column 400 times, but rows with both "Timmy" and "widget"
in their respective columns only occur 5 times. How in the heck can I
do this? What I'm looking for is a nested countif formula (or
whatever) that returns "5" and I'm befuddled.

By the way, SalesManager and ProductItem are range names for the
columns, if that matters.
 
I used the formula and it resulted with a #NUM!. I tried this earlier
today and gave up thinking that it required numeric data. Perhaps it's
a problem with the way the cells are formatted?

Any other suggestions?
 
What formula did you use?

If you used range names, what were the addresses of those ranges?

Did the data in those ranges have any errors (#num!, especially) in them?
 
Back
Top