simple COUNTIF Sheet Summery formula
need help with this simple formula for a sheet summary
=COUNTIF([IEP Status], "NEW (not signed)", "Active", "Active (Needs Att.)")
something is wrong with the formatting I want to count number rows that contain these specific drop down list values. I put the values in quotes but the parentheses from the drop down values are turning pink which I think means they are registering as part of the formula. do i need to remove the parentheses from my drop down values for this to work right?
Help Article Resources
Check out the Formula Handbook template!