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?
thanks much!
Best Answer
-
Give this a shot:
=COUNTIF([IEP Status]:[IEP Status], OR(@cell = "NEW (not signed)", @cell = "Active (Needs Att.)"))
Answers
-
Give this a shot:
=COUNTIF([IEP Status]:[IEP Status], OR(@cell = "NEW (not signed)", @cell = "Active (Needs Att.)"))
-
that's quite a bit of additional formatting I don't quite understand... but it works great
thanks you!
Help Article Resources
Categories
Check out the Formula Handbook template!