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
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.6K Get Help
- 433 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.9K Ideas & Feature Requests
- 143 Brandfolder
- 147 Just for fun
- 63 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 298 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!