Formula Help
I am for some reason having an issue getting function to calculate correctly. I need to pull the count for just active projects in one column but it is calculating all of them. There should only be 143. Can anyone help with this?
=SUMIF([Project Phase]:[Project Phase], "Active")
=COUNTIF([Project Phase]:[Project Phase], "Active")
=COUNTIFS([Project Phase]:[Project Phase], "Active")
Minni Florence
Senior Project Coordinator
Industrial Properties Construction
Answers
-
Try a COUNTIFS instead.
-
I have tried it and it is not giving m the correct number. I have tried SUM, SUMIF, SUMIFS, COUNT, COUNTIF, and COUNTIFS and it is just not working
Minni Florence
Senior Project Coordinator
Industrial Properties Construction
-
what count is it giving you when you use the =COUNTIF([Project Phase]:[Project Phase], "Active")
-
Have you double checked that there are no filters applied to the source data?
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 472 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 496 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!