+ Post New Thread
Results 1 to 2 of 2
Office Software Thread, COUNTIF > Symbol in Technical; Am I messing this up? I am sure it works. I have a formula that calculates student residuals and returns ...
  1. #1
    CAM
    CAM is offline

    CAM's Avatar
    Join Date
    Mar 2008
    Location
    Burgh Heath, Surrey
    Posts
    4,022
    Thank Post
    803
    Thanked 346 Times in 270 Posts
    Blog Entries
    60
    Rep Power
    278

    COUNTIF > Symbol

    Am I messing this up? I am sure it works. I have a formula that calculates student residuals and returns a numerical results that is positive or negative. I am trying to work out how many have a score greater then 0 with a second formula using COUNTIF to analyse the results. My COUNTIF formula looks right but it says there is an error every time.

    Code:
    =COUNTIF(AH3:AH152,>0)
    What's wrong with it?

    EDIT - Didn't wrap my criteria in quote marks.

    Code:
    =COUNTIF(AH3:AH152,">0")
    So uhh...yeah. Another case where I seek help then find the answer minutes later. I've been stumped on this for weeks and sure I tried that! >.<

    Oh well, answer is here for those that need it.
    Last edited by CAM; 30th July 2013 at 09:53 AM.

  2. #2
    jimbojames136's Avatar
    Join Date
    Mar 2011
    Location
    Hull
    Posts
    29
    Thank Post
    6
    Thanked 1 Time in 1 Post
    Rep Power
    0
    CAM,

    Sorry I know this is an old post. I searched for Residual and this came up.

    Can I ask how did you manage to calculate Residual for a student? I am currently trying to do this for KS5 students.
    any help would be amazing.

    thanks

SHARE:
+ Post New Thread

Similar Threads

  1. [MS Office - 2003] COUNTIF Fuction
    By vunsev in forum Office Software
    Replies: 8
    Last Post: 9th March 2009, 06:01 PM
  2. apple mac nvidia 8800 GT ?
    By mac_shinobi in forum Mac
    Replies: 2
    Last Post: 4th November 2008, 01:49 PM
  3. Set Your Video - Nissan GT-R vs Japanese Bullet Train
    By SYSMAN_MK in forum General Chat
    Replies: 15
    Last Post: 14th July 2008, 02:53 PM
  4. Pound symbol in Joomla
    By Singist in forum EduGeek Joomla 1.0 Package
    Replies: 5
    Last Post: 12th June 2008, 03:13 PM
  5. Nvidia Model codes - whats best? GS/GTS/GT
    By j17sparky in forum Hardware
    Replies: 21
    Last Post: 4th December 2007, 01:02 PM

Thread Information

Users Browsing this Thread

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

Posting Permissions

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