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.
Surface Pro (2017) vs Surface Pro 4
20 groundbreaking 3D animation techniques
How to mine Bitcoin on Mac