simple COUNTIF Sheet Summery formula

Dell55

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?

thanks much!

Carson Penticuff

Give this a shot:

=COUNTIF([IEP Status]:[IEP Status], OR(@cell = "NEW (not signed)", @cell = "Active (Needs Att.)"))

Carson Penticuff

Give this a shot:

=COUNTIF([IEP Status]:[IEP Status], OR(@cell = "NEW (not signed)", @cell = "Active (Needs Att.)"))

Dell55

that's quite a bit of additional formatting I don't quite understand... but it works great

thanks you!