COUNTIF Problem - Formula returns #Value

**MCoev** · 03-01-2012, 02:48 PM

=COUNTIFS('BusinessData'!E:E,$D$9,'BusinessData'!I:P,B10)

So I am looking to create a tally of the number other businesses that customers visit when they visit a specific store. Surveys were done at around 50 stores, so $D$9 contains the name of the one I want to focus on. Columns I:P contain the names of other stores that people visited after the one that they completed the survey in. I want to count, in every row where Column E equals D9, how many times the names of other stores are mentioned (the name of the other store is in B10 in this case).

With that code I get #VALUE message, the code below worked for the data as a whole, but now i want to specify each business.