I am using a sum array (ctrl+shift+enter).. and I have a formula where i want
to test condition but use an "OR" statment.

ie: if title="EA" or class take is "Word", sum how many?

{=SUM((A8:A13="EA")+(B8:B13="Word")) but this equation totals duplicates
too. I only want it to count once, if in one row has either EA or Word.