named range referenced in formula

Hi kersplash,

The first screenshot is the sample matrix translated in english.
The actual matrix is in japanese, where the same word can have different spelling (which is why i need this named range).
Basically i want to count the number of sentences that has this one body part A with this one symptom B,
repeating this with however many body parts and symptoms there are.

Hope this helps,