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!
Last edited by jaysenoz; 03-10-2021 at 02:45 PM.
Hi,
Do you have a sample sheet to upload?
Look at the yellow banner at the top of the page to see how to attach a workbook.
The workbook should be attached to this reply.Originally Posted by belinda200
Try this :
D35 and drag to the right:
=SUM(COUNTIFS(D6:D31,{"N"},$A$6:$A$31,"<>EXCLUDE")*{1})
D33 and drag to the right:
=SUMPRODUCT(($A$6:$A$31<>"exclude")*(--(EXACT(D6:D31,{"D","AM","PM"})*{1,0.5,0.5})))
That works perfectly. Can you explain how I would add a different row to exclude if I have to in the future?
Add the word "Exclude" in column A like you did in the existing 2....
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks