+ Reply to Thread
Results 1 to 9 of 9

How To Highlight the last result of SUMIFS

  1. #1
    Forum Contributor
    Join Date
    07-06-2013
    Location
    Borneo
    MS-Off Ver
    2016
    Posts
    277

    How To Highlight the last result of SUMIFS

    Dear Expert and the other

    could you help me how to Highlight the last result of SUMIFS in this sample
    Attached Files Attached Files

  2. #2
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    43,984

    Re: How To Highlight the last result of SUMIFS

    What's the logic??? Highlight the last non-blank cell in column L? Why is L3 highlighted? Please explain in more detail what you want.
    Glenn




    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.

    Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh

  3. #3
    Forum Contributor
    Join Date
    07-06-2013
    Location
    Borneo
    MS-Off Ver
    2016
    Posts
    277

    Re: How To Highlight the last result of SUMIFS

    actually I need to mention one result in the last cell, L2 & L3 is same

  4. #4
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    43,984

    Re: How To Highlight the last result of SUMIFS

    I do not understand what you have just said...

  5. #5
    Forum Contributor
    Join Date
    07-06-2013
    Location
    Borneo
    MS-Off Ver
    2016
    Posts
    277

    Re: How To Highlight the last result of SUMIFS

    L3 and L2 same, but could it be highlight, perhaps by using conditional formatting for the last cell result?

  6. #6
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    43,984

    Re: How To Highlight the last result of SUMIFS

    I think I understand. Why no highlight of L4? It is also a last value...

  7. #7
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    43,984

    Re: How To Highlight the last result of SUMIFS

    Maybe this:
    =AND(COUNTIFS($C$2:C2,C2,$D$2:D2,D2,$L$2:L2,L2)=COUNTIFS(C:C,C2,D:D,D2,L:L,L2),COUNTIFS(C:C,C2,D:D,D2,L:L,L2)<>1)
    Attached Files Attached Files

  8. #8
    Forum Contributor
    Join Date
    07-06-2013
    Location
    Borneo
    MS-Off Ver
    2016
    Posts
    277

    Re: How To Highlight the last result of SUMIFS

    L4, L7 and same result

  9. #9
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    43,984

    Re: How To Highlight the last result of SUMIFS

    Once agaain, I do not understand you. The sheet highlights the two cells required. If that is not what is wanted, repost yous sheet showing what IS wanted.

+ 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] Sumifs/Index formula - no result
    By Roma1r in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 04-12-2019, 08:41 PM
  2. [SOLVED] VBA How can SUMIFs result be stored in an array and then populated
    By Flora20 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-05-2017, 06:53 AM
  3. [SOLVED] If no SUMIFS matches, 1, otherwise the SUMIFS result...
    By JYTS in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 12-04-2016, 07:39 PM
  4. [SOLVED] SUMIFS - #VALUE and not a result
    By Vestlink in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-05-2015, 04:54 AM
  5. how to highlight cell linked with sumifs function
    By sumeet kumar in forum Hello..Introduce yourself
    Replies: 1
    Last Post: 09-20-2013, 04:28 PM
  6. SUMIFS Puzzle - Trying to avoid adding multiple SUMIFS to get valid result
    By haldavid in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 01-09-2013, 03:42 PM
  7. [SOLVED] SUMIFS + condition on result
    By Davzx in forum Excel General
    Replies: 4
    Last Post: 06-28-2012, 12:59 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