+ Reply to Thread
Results 1 to 5 of 5

Sumproduct using blank cells

  1. #1
    Forum Contributor
    Join Date
    03-08-2007
    Location
    St. Augustine, Fl
    MS-Off Ver
    2012 and 2011 MAC
    Posts
    343

    Sumproduct using blank cells

    I have a grade file with this formula in B12.
    Please Login or Register  to view this content.
    . When I put what percent I want the grade to count in row 9 the formula in B12 uses it to get the raw score even if there is no grade put in as in I12 in the attached file. How can I get it to work for only students that have an actual score on the work?
    Attached Files Attached Files
    Last edited by Wskip49; 12-18-2008 at 03:53 PM.

  2. #2
    Cheeky Forum Moderator Ron Coderre's Avatar
    Join Date
    03-22-2005
    Location
    Boston, Massachusetts
    MS-Off Ver
    2013, 2016, O365
    Posts
    6,996

    Calc Cumulative Pct

    Looking at your posted workbook....
    I believe the problem is in cell AU9
    Try this:

    Please Login or Register  to view this content.
    Does that help?
    Last edited by Ron Coderre; 12-18-2008 at 11:06 AM. Reason: add an alternative formula
    Ron
    Former Microsoft MVP - Excel (2006 - 2015)
    Click here to see the Forum Rules

  3. #3
    Forum Contributor
    Join Date
    03-08-2007
    Location
    St. Augustine, Fl
    MS-Off Ver
    2012 and 2011 MAC
    Posts
    343
    That gives me the same raw score for B12 but for all the rest it want work. I think the variable in AU9 has to apply to all students. In the original file I have over 20 students listed.

  4. #4
    Cheeky Forum Moderator Ron Coderre's Avatar
    Join Date
    03-22-2005
    Location
    Boston, Massachusetts
    MS-Off Ver
    2013, 2016, O365
    Posts
    6,996

    Effective Wgt Pcts

    I think I understand....

    IF...The Cumulative Weight Pct can be different for each student (based on
    whether they have a score for a particular item), then try this:

    Please Login or Register  to view this content.
    Copy those formulas down for each student.

    HOWEVER...if the Cumulative Weight Pct is static for ALL students and
    each pct is only used when ANY student has a score for that category,
    then: I'd put Effective Weight Pct formulas under each Weight Pct to
    determine if it's used or not:
    Please Login or Register  to view this content.
    Then you can use your original formulas, but reference $AU$10, instead of $AU$9.

    Does that help?

  5. #5
    Forum Contributor
    Join Date
    03-08-2007
    Location
    St. Augustine, Fl
    MS-Off Ver
    2012 and 2011 MAC
    Posts
    343
    Those Work Great. Thank you so much.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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