All,
I have 2 sheets. Sheet 2 has a list of Software (SW) and Sheet 1 has
multiple fields that include Name (A2 through A50000) and SW (F2 through
F50000). The Names are repeated for all the different SW they have. See
example:
A F
Joe Word
Joe Excel
Bob Word
Sue Word
Sue Excel
#N/A Word
#N/A Excel

What I'd like to do is in Sheet 2 create 2 formulas. 1 that would count the
number of times a certain SW from sheet 2 appears in sheet 1 associated with
a name. 2 would count the number of times a certain SW from sheet 2 appears
in sheet 1 associated with "#NA".

Formula 1 would return a value of 3 for Word and 2 for Excel while formula 2
would return 1 for each. I've tried several methods including Sumif,
IF(Countif) and Vlookup with And and no such luck. Any help you could
provide would be greatly appreciated. Thanks.

Jack