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.5K Get Help
- 424 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 145 Just for fun
- 63 Community Job Board
- 465 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!