Modify Sheet Summary field

Question

Currently have a field in my sheet summary with this formula: =COUNTIFS(Finish:Finish, <=TODAY(+14), Finish:Finish, >=TODAY(), [Helper Parent Column]:[Helper Parent Column], <>"", Status:Status, <>"Complete") I would like to add if the Status is "Not Needed". How do I modify the formula?

Paul Newcome · Answer

Ok. In that case you have two options. You can either create another range/criteria set the same way you did with the date requirements, or you could combine the criteria for the same range using an AND statement. =COUNTIFS(Finish:Finish, AND(@cell <= TODAY(+14), @cell >= TODAY()), [Helper Parent Column]:[Helper Parent Column], <>"", Status:Status, AND(@cell <> "Complete", @cell <> "Not Needed"))

PMOGal · Answer

Exclude like I am ex

Paul Newcome · Answer

Do you mean to specifically count rows where the status is "Not Needed", or are you wanting to exclude those the same way you are excluding "Complete"?