Match this cell on a different tab, four times formula

[bowenable]

Hey all, not sure how to explain this, but I'll try my best,

I am looking for a formula to do the following:

If A1 matches A2, then add 2 points (+2) to A3,
If B1 matches B2, then add 2 points (+2) to A3,
if C1 matches C2, then add 2 points (+2) to A3
If D1 matches D2, then add 2 points (+2) to A3.

So hypothetically, if all 4 are positive matches, then A3 should equal 8.


Bowenable

 

[Scott T]

Try

=IF(A1=A2,2,0)+IF(B1=B2,2,0)+IF(C1=C2,2,0)+IF(D1=D2,2,0)