I am having a major issue in getting an array formula to work for in counting multiple criteria. I am looking for the intersection of two types of data. One column (E2:E413) has data that has been coded 1,2,3, or 4. Another column (T2:T413) has data that has been coded 1,2,3,4,5,7, or 8. I am trying to count (not sum) how many times that both 1 shows up in column E AND 1 shows up in column T.
I have tried many different formulas, but I'm a novice at Excel and am need of help. The only familiarity I have with this program comes from the misery I've had with it in the last few days. Below are two of formulas that I have tried (found them via web), but to no avail:

=SUM(IF($E$2:$E$120="1",IF($T$2:$T$120="1",1,0),0))
=SUM(($E$2:$E$413="1")*($T$2:$T$413="1"))

If anyone can help, I would be so super appreciative.

Thanks,
Tiffany