We need a better description of your worksheet layout - i.e. exactly what you have and where - and what you are trying to achieve. From your brief outline I would say that you need a SUMPRODUCT, not a combination of IF and AND.
WPA2 hack: How secure is your Wi-Fi?
HP’s new Surface Pro rival is designed specifically for Adobe-using designers and artists
Best kids apps for iPhone & iPad
Que faire si son iPhone ou iPad est tombé dans de l'eau ?