Issue with formula in sheet summary
I am having an issue with my formula:
=COUNTIFS([Start Date]:[Start Date], IFERROR(MONTH(@cell), 0) >= 7, Type:Type, OR(@cell = "Residence Life Event", @cell = "6 in first 6", @cell = "Welcome Back Event", [P.A.W.S (Res Life Only)]:[P.A.W.S (Res Life Only)], "Philanthropic"))
I want it to count events that are equal to or greater than a start date of July (7), if the Type is selected as either a Residence Life Event, 6 in first 6, or Welcome Back Event, and if the column P.A.W.S (Res Life Only) is selected as Philanthropic.
Help Article Resources
Check out the Formula Handbook template!