Hello,
I am trying to exclude two rows from being added into a calculation. I use the two formulas on a shift schedule to highlight red if our day or night shift has less than 2 people and to highlight green if it has 2 or more people. The formulas are as follows:
Day:
=SUMPRODUCT(--(EXACT(C6:C31,{"D"})*{1}))
Night:
=SUM(COUNTIF(C6:C31,{"N"})*{1})
I need to exclude row 12 and 21 from being included in the formula.
Any help would be greatly appreciated! Thank you!
Bookmarks