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"))
Help Article Resources
Check out the Formula Handbook template!