+ Reply to Thread
Results 1 to 5 of 5

Countif formula help for school

  1. #1
    Registered User
    Join Date
    09-21-2014
    Location
    https://t.me/pump_upp
    MS-Off Ver
    2013
    Posts
    2

    Countif formula help for school

    Hi,

    I need some help for a my school. I have the responsibility of analysing students behaviour. I have created a excel document but need help with a formula.

    excel.png

    I need a countif formula or whatever works best for

    Cell O3 to increase if cells J8 is greater than or equal to K8. This needs to happen for the cells down over.

    Thanks in advanced

    Michael
    Attached Files Attached Files
    Last edited by neesham; 01-06-2019 at 04:16 AM.

  2. #2
    Forum Expert
    Join Date
    11-28-2012
    Location
    Guatemala
    MS-Off Ver
    Excel 2010
    Posts
    2,394

    Re: Help for school

    Please attach the template so WE can work with it.

  3. #3
    Registered User
    Join Date
    09-21-2014
    Location
    https://t.me/pump_upp
    MS-Off Ver
    2013
    Posts
    2

    Re: Help for school

    I have attached the documents. The students need to make above the points that is identified in rows K & Y. Some students have different points targets that is why i am unable to use 38.
    If the points in J & X equal too or greater than the number in K & Y. Count in O3.

    Hope this makes sense.

    MJ
    Attached Files Attached Files

  4. #4
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,448

    Re: Help for school

    Thread title somewhat more descriptive
    Last edited by Pepe Le Mokko; 01-06-2019 at 11:08 AM.

  5. #5
    Forum Expert
    Join Date
    11-28-2012
    Location
    Guatemala
    MS-Off Ver
    Excel 2010
    Posts
    2,394

    Re: Help for school

    I used columns N and AB to stage a 1 on 1 comparison to allow the targets numbers to be different. I hid the results by selecting the color of the font to white
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Old, OLD school ...
    By bjack258 in forum Hello..Introduce yourself
    Replies: 1
    Last Post: 02-29-2016, 06:25 PM
  2. School Management
    By gordonsnyders in forum Excel General
    Replies: 1
    Last Post: 01-29-2016, 03:02 AM
  3. [SOLVED] home school help
    By Home school in forum Excel General
    Replies: 1
    Last Post: 08-19-2006, 11:58 AM
  4. School teacher
    By Vasant Nanavati in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 09-06-2005, 07:05 AM
  5. School teacher
    By Vasant Nanavati in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 09-06-2005, 06:05 AM
  6. [SOLVED] School teacher
    By yeahbaby in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 02:05 AM
  7. [SOLVED] School teacher
    By yeahbaby in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 01:05 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1