Hi guys -
So I tried the following formula but it is giving me the wrong count:
I'm trying to get the counts of Group 1 + Group 2 where their status is Current, Proposed, or Dormant. The SUM/COUNTIFS formula seems to not work - can you only have one {} in a sum countif? Is there a better way of doing this?![]()
=SUM(COUNTIFS(Tracker!$CI$3:$CI$3000, {"Group 1","Group 2"}, Tracker!$G$3:$G$3000,{"Current","Proposed","Dormant"}))
Thanks!
John
Bookmarks