Add an if statement to the formula i have

[patsyhixon]

Hey guys hello, back again
The formula I am using =IF(AND(A2<>1,A2<>2),C2,80-SUMPRODUCT(($A$2:$A$572<>1)*($A$2:$A$572<>2)*($B$2:$B$572=$B2),$C$2:$C$572)) works great, I just need to add if in A column there is a 2 it equals 0. I have added the formula =if(a2=2, 0, "") everywhere in the formula and can not get it to work. Here is the sample worksheet. As always I really appreicate you guys.

UPLOAD.xlsx

[NBVC]

Unfortunately:

This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

Thread Closed.