Help Needed
Hello, All.
I need to create a formula where I am summing particular values in the same column wherever that value appears. For example, if 1 appears 5 times in the column, I wish the formula to return 5. However, I also wish this formula to sum up 2 other values in the column if they appear (column value equals that value).
This is the formula I am working with. I keep receiving the error message "INVALID DATA TYPE." Any assistance you can lend would be appreciated.
=COUNTIFS([Project Status]:[Project Status], ="Phase 1", OR([Project Status]:[Project Status], ="Phase 2", [Project Status]:[Project Status], ="Phase 3"))
Answers
-
Hope you are fine, please try the following
=COUNTIFS([Project Status]:[Project Status], "Phase 1", OR([Project Status]:[Project Status], "Phase 2", [Project Status]:[Project Status], "Phase 3"))
bassam.khalil2009@gmail.com
☑️ Are you satisfied with my answer to your question? Please help the Community by marking it as an ( Accepted Answer), and I will be grateful for your "Vote Up" or "Insightful"
-
Thank you Bassam. I cut and pasted this formula in to the field to give it a try. The response returned was #INVALID DATA TYPE. I am wondering if there is another way to designate which fields should be counted.
-
Could you please share me as an admin on a copy of your sheet ( after removing any sensitive data ) and I will check it
bassam.khalil2009@gmail.com
☑️ Are you satisfied with my answer to your question? Please help the Community by marking it as an ( Accepted Answer), and I will be grateful for your "Vote Up" or "Insightful"
-
Good Morning, Bassam.
I really wish I could grant you such access. This Smartsheet is being created within my company's firewall, so sharing access to external parties is not allowed.
Thank you so much for your offer to help! It is very much appreciated!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 471 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!