How can fix my COUNTIFS formula, where I have 5 ranges (columns), but want to exclude a value range in 2 of the columns respectively. =COUNTIFS({Range 6}, "05. Trust Administration", {Range 3}, "Bokamoso"), {Range 2}, "Must Do", NOT({Range 1}, "Existing Project", {Range 5}, "Done") What I need to count all items in Ranges…
