+ Reply to Thread
Results 1 to 5 of 5

Countifs formula not working with multiple cells

  1. #1
    Registered User
    Join Date
    04-05-2013
    Location
    India
    MS-Off Ver
    Excel 2010
    Posts
    56

    Countifs formula not working with multiple cells

    Dear Sirs,

    Please refer to my attached sheet formula in YELLOW HIGHLIGHT for "Completed Score" is not working. Please help me out on this.

    Thanks in advance..!!

    Nitin Kumar
    Attached Files Attached Files

  2. #2
    Forum Expert PaulM100's Avatar
    Join Date
    10-09-2017
    Location
    UK
    MS-Off Ver
    2016
    Posts
    2,100

    Re: Countifs formula not working with multiple cells

    Based on your formula i would go with something like:
    =SUMPRODUCT(($C$11:$C$22=$P$11)*($D$11:$I$22=$O$11))*Q11+SUMPRODUCT(($C$11:$C$22=$P$12)*($D$11:$I$22=$O$11))*$Q$12+SUMPRODUCT(($C$11:$C$22=$P$13)*($D$11:$I$22=$O$11))*$Q$13
    Click the * to say thanks.

  3. #3
    Registered User
    Join Date
    04-05-2013
    Location
    India
    MS-Off Ver
    Excel 2010
    Posts
    56

    Re: Countifs formula not working with multiple cells

    Dear Sir,

    Thanks a lot for your prompt concern; the formula which you suggested is giving value more than Total Score which is 40 and completed score comes to 240 whwich is incorrect . Request please review.

    Nitin

  4. #4
    Forum Expert PaulM100's Avatar
    Join Date
    10-09-2017
    Location
    UK
    MS-Off Ver
    2016
    Posts
    2,100

    Re: Countifs formula not working with multiple cells

    Well, you did not had a desired result. I assumed that you needed to count the completed for each Lane and for each priority, then multiply them by the weightage. If this is not the case, then what logic should apply?

  5. #5
    Registered User
    Join Date
    04-05-2013
    Location
    India
    MS-Off Ver
    Excel 2010
    Posts
    56

    Re: Countifs formula not working with multiple cells

    well yes right formula is right as per logic i need to multiply Total Score by total number of lanes
    Thanks o lot..!!

+ 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. [SOLVED] Countifs Data validation cells not working
    By SHUTTEHFACE in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 09-04-2018, 05:58 PM
  2. [SOLVED] Multiple CountIfs Not Working
    By Dal123 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-14-2018, 02:15 PM
  3. [SOLVED] Multiple COUNTIFS formulas in one cell is not working.
    By Jriggerz in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 10-10-2017, 09:22 AM
  4. COUNTIFS(INDEX Formula Not Working
    By dy137 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-04-2017, 10:05 AM
  5. Countifs formula not working
    By oneblondebrow in forum Excel General
    Replies: 4
    Last Post: 11-10-2016, 09:20 AM
  6. Counts with multiple criteria, COUNTIFS not working
    By IbeforeV in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 12-01-2014, 01:22 PM
  7. Countifs FOrmula Not working
    By cartica in forum Excel General
    Replies: 1
    Last Post: 10-30-2013, 01:34 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