Hey guys!
This is what i have at the moment, (its a mailing list)
CELL B5 =COUNTIF(*****!U2:U101,"YES")
CELL C5 =COUNTIF(*****!U2:U101,"NO")
CELL D5 =COUNTIF(*****!U2:U101,"RETURNED")
What I want to do is every time we color the cell a certain color like yellow, it will not count that cell.
Every month we submit a separate sheet to accounting and this should keep it updated without the hassle of manually counting. But every month we only count only the un-highlighted ones.
So what can I do to have it not count yellow highlighted cells???
Thanks!
This is what i have at the moment, (its a mailing list)
CELL B5 =COUNTIF(*****!U2:U101,"YES")
CELL C5 =COUNTIF(*****!U2:U101,"NO")
CELL D5 =COUNTIF(*****!U2:U101,"RETURNED")
What I want to do is every time we color the cell a certain color like yellow, it will not count that cell.
Every month we submit a separate sheet to accounting and this should keep it updated without the hassle of manually counting. But every month we only count only the un-highlighted ones.
So what can I do to have it not count yellow highlighted cells???
Thanks!