Results 1 to 9 of 9
  1. #1
    Veteran ace3g's Avatar
    My Team
    San Antonio Spurs
    Join Date
    Jul 2005
    Post Count
    32,001
    If I have a condition =COUNTIF($M$2:$R$27,B2)>=1 that turns certain cells green, how can I count those cells in row that are green? Range that turns green is: =$B$2:$G$39 -- First row I want to count is B2:G2.

    I think I almost figured it out: =SUM(COUNTIF(B2:G2,$M$2:$R$27)) but I only want it to count the first time a number in B2:G2 matches numbers from M2:R27, no duplicates.

  2. #2
    🏆🏆🏆🏆🏆 ElNono's Avatar
    My Team
    San Antonio Spurs
    Join Date
    Apr 2007
    Post Count
    130,547

  3. #3
    Savvy Veteran spurraider21's Avatar
    My Team
    San Antonio Spurs
    Join Date
    Apr 2012
    Post Count
    74,371
    Did you try turning it off and back on?

  4. #4
    黒人の命は大切だ baseline bum's Avatar
    My Team
    San Antonio Spurs
    Join Date
    Mar 2003
    Post Count
    77,016
    Use console instead, but wait for the new XBox.

  5. #5
    Veteran ace3g's Avatar
    My Team
    San Antonio Spurs
    Join Date
    Jul 2005
    Post Count
    32,001
    By the way this is a legit post, not from a robot. I was hoping someone with excel knowledge could help.

  6. #6
    Veteran ace3g's Avatar
    My Team
    San Antonio Spurs
    Join Date
    Jul 2005
    Post Count
    32,001
    I finally got this resolved, disregard.

  7. #7
    Veteran SpursforSix's Avatar
    My Team
    San Antonio Spurs
    Join Date
    Jul 2015
    Post Count
    17,377
    Did you try turning it off and back on?
    I finally got this resolved, disregard.
    it worked, didn't it

  8. #8
    coffee's for closers FrostKing's Avatar
    My Team
    Chicago Bulls
    Join Date
    Aug 2018
    Post Count
    6,581

  9. #9
    LMAO koriwhat's Avatar
    My Team
    San Antonio Spurs
    Join Date
    Jan 2008
    Post Count
    25,520

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
  •