Hi,

I recently got the answer to an IF and AND formula that works brilliantly, but now I need to add a further condition to my criteria.

The scenario is that I need to add up student scores and work out who has at least 1 point in each category, plus a minimum of 50 points overall.

The current formula can do the working out who has the 1pt in each category, I just can't get the AND has 50 points or more into it as well.

All help appreciated