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.
Did you try turning it off and back on?
Use console instead, but wait for the new XBox.
By the way this is a legit post, not from a robot. I was hoping someone with excel knowledge could help.
I finally got this resolved, disregard.
it worked, didn't it
There are currently 1 users browsing this thread. (0 members and 1 guests)