We still use the above at my primary school! It is possible to create an if ... then formula where it looks for the value in a box and then creates a counter? I'm an EYFS teacher and I want it to look in a particular range of cells and make a count of all children who score 6+. I've looked at internet help sites and Microsoft's help and I don't understand it. Or I think I do but it just writes FALSE in the box.