1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.
  2. Hi Guest, welcome to the TES Community!

    Connect with like-minded education professionals and have your say on the issues that matter to you.

    Don't forget to look at the how to guide.

    Dismiss Notice

Microsoft Excel 2003

Discussion in 'Computing and ICT' started by Leapyearbaby64, Jul 4, 2011.

  1. Leapyearbaby64

    Leapyearbaby64 New commenter

    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.
     
  2. If the range of cells that contain the values is A1 to A20 then the formula would be
    =COUNTIF(A1:A20, ">5")
    This would count the number of scores that were 6 or above.
     

Share This Page