countif with text data in two ranges

[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.

 

[Jim]

=SUMPRODUCT((ManagerNames="Timmy")*(ProductNames="widget"))

 

[psr]

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?

 

[Jim]

Assuming you dreferenced two EQUAL ranges, that works correctly. Be sure you
have double parenteses on both ends of the formula.

--
Greeting from the Gulf Coast!
http://myweb.cableone.net/twodays

=SUMPRODUCT((ManagerNames="Timmy")*(ProductNames="widget"))

 

[Dave Peterson]

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?