Results 1 to 30 of 30

Help require to insert countif function and shorten the formula

Threaded View

  1. #3
    Forum Contributor
    Join Date
    06-29-2014
    Location
    India
    MS-Off Ver
    2010 Windows 10 64 bits
    Posts
    1,269

    Re: Help require to insert countif function and shorten the formula

    Hi daffodil11,
    First of all I thank you for providing me tips to make my formula more easier to read and understand. I will definately follow your guidelines in future.

    Thank you for shortening the formula. However you missed a main condition that the should be passed in minnimum 3 subjects to get grace marks for passing.

    I want to use this formula for all subjects.
    The total of grace marks is limited to 15 only.
    The table of grace marks is as follows:
    Average ... Grace
    20: 15
    21: 14
    22: 13
    23: 12
    24: 11
    25: 10
    26: 9
    27: 8
    28: 7
    29: 6
    30: 5
    31: 4
    32: 3
    33: 2
    34: 1
    35: 0

    It's same for all subjects and the total of all should be 15 only.

    I'm attaching my workbook here for your better understanding.

    Thanking you in anticipation.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Require a code to insert formula in visible cell range only
    By mukeshbaviskar in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-12-2014, 08:25 PM
  2. Proper syntax to shorten Countif formula
    By small_wonder in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 10-01-2012, 09:23 AM
  3. How to shorten the formula - IF(SUM(COUNTIF(
    By fang603 in forum Excel General
    Replies: 2
    Last Post: 03-09-2012, 08:59 AM
  4. How can i shorten up this function / formula?
    By Salandar in forum Excel General
    Replies: 12
    Last Post: 10-21-2008, 01:20 PM
  5. [SOLVED] CountIf Function - require range of criterea
    By John F in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 04-27-2005, 06:06 PM

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