论坛档案

If you only want to add those if the Status is Approved, you'd use this formula:<\/p>

=SUMIFS([Approved Change Order Amount.]:[Approved Change Order Amount.], Category:Category, CONTAINS(\"Regulatory Submissions\", @cell), Status:Status, \"Approved\")<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question","log":{"dateUpdated":"2022-10-21 21:33:13","updateUser":{"userID":154015,"name":"Vane","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Vane","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-10-21T22:08:16+00:00","banned":0,"punished":0,"private":true,"label":"✭"}}},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":[]},"reactions":[{"tagID":3,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":5,"urlcode":"Insightful","name":"Insightful","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":13,"urlcode":"Awesome","name":"Awesome","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}],"tags":[]},{"discussionID":96887,"type":"question","name":"Help with COUNTIF","excerpt":"Currently I am counting the number of rows assigned to a particular person using a separate sheet. Currently it counts every row based on the value of the adjacent column. The current entry in the cell that displays the count is =COUNTIF({Sheet - Request Tracker Range 9}, Category26). I need to be able to count the number…","categoryID":322,"dateInserted":"2022-10-21T17:48:50+00:00","dateUpdated":null,"dateLastComment":"2022-10-21T17:59:27+00:00","insertUserID":154002,"insertUser":{"userID":154002,"name":"SmartSheet Newbie","url":"https:\/\/community.smartsheet.com\/profile\/SmartSheet%20Newbie","photoUrl":"https:\/\/lh3.googleusercontent.com\/a\/ALm5wu1VcnmvyGv6lWBPJmcBlo2-f4c9qfr0HlrcGUdo=s96-c","dateLastActive":"2022-10-21T18:00:34+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":45516,"lastUser":{"userID":45516,"name":"Paul Newcome","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Paul%20Newcome","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/082\/nQPUTVFKKWDJ2.jpg","dateLastActive":"2022-10-21T17:57:45+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":12,"score":null,"hot":3332750297,"url":"https:\/\/community.smartsheet.com\/discussion\/96887\/help-with-countif","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/96887\/help-with-countif","format":"Rich","lastPost":{"discussionID":96887,"commentID":348294,"name":"Re: Help with COUNTIF","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/348294#Comment_348294","dateInserted":"2022-10-21T17:59:27+00:00","insertUserID":45516,"insertUser":{"userID":45516,"name":"Paul Newcome","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Paul%20Newcome","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/082\/nQPUTVFKKWDJ2.jpg","dateLastActive":"2022-10-21T17:57:45+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions"}],"groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2022-10-21T18:04:48+00:00","dateAnswered":"2022-10-21T17:59:27+00:00","acceptedAnswers":[{"commentID":348294,"body":"

You would switch over to a COUNTIFS to include multiple range\/criteria sets, include the new range, and then include the new criteria.<\/p>

=COUNTIFS<\/strong>({Sheet - Request Tracker Range 9}, Category26, {New Range}, AND(@cell <> \"Closed\", @cell <> \"Cancelled\")<\/strong>)<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question","log":{"dateUpdated":"2022-10-21 18:04:48","updateUser":{"userID":154002,"name":"SmartSheet Newbie","url":"https:\/\/community.smartsheet.com\/profile\/SmartSheet%20Newbie","photoUrl":"https:\/\/lh3.googleusercontent.com\/a\/ALm5wu1VcnmvyGv6lWBPJmcBlo2-f4c9qfr0HlrcGUdo=s96-c","dateLastActive":"2022-10-21T18:00:34+00:00","banned":0,"punished":0,"private":false,"label":"✭"}}},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":[]},"reactions":[{"tagID":3,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":5,"urlcode":"Insightful","name":"Insightful","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":13,"urlcode":"Awesome","name":"Awesome","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}],"tags":[]},{"discussionID":96879,"type":"question","name":"Plus sign in front of a cell value","excerpt":"We just noticed a plus sign appeared in front of a value in a sheet and when you click on it, it becomes a minus. How did it get there? What does it mean and how do we remove?","categoryID":321,"dateInserted":"2022-10-21T15:29:50+00:00","dateUpdated":null,"dateLastComment":"2022-10-21T16:48:45+00:00","insertUserID":146968,"insertUser":{"userID":146968,"name":"Alta","url":"https:\/\/community.smartsheet.com\/profile\/Alta","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-10-21T16:49:12+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":8888,"lastUser":{"userID":8888,"name":"Andrée Starå","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Andr%C3%A9e%20Star%C3%A5","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/pictures\/f4\/d4\/nf4d40b307033e1c1fd4cfe2ab2c10220.jpg","dateLastActive":"2022-10-21T18:40:50+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":11,"countViews":24,"score":null,"hot":3332743715,"url":"https:\/\/community.smartsheet.com\/discussion\/96879\/plus-sign-in-front-of-a-cell-value","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/96879\/plus-sign-in-front-of-a-cell-value","format":"Rich","lastPost":{"discussionID":96879,"commentID":348265,"name":"Re: Plus sign in front of a cell value","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/348265#Comment_348265","dateInserted":"2022-10-21T16:48:45+00:00","insertUserID":8888,"insertUser":{"userID":8888,"name":"Andrée Starå","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Andr%C3%A9e%20Star%C3%A5","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/pictures\/f4\/d4\/nf4d40b307033e1c1fd4cfe2ab2c10220.jpg","dateLastActive":"2022-10-21T18:40:50+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Using Smartsheet","url":"https:\/\/community.smartsheet.com\/categories\/using-smartsheet"},{"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B"}],"groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2022-10-21T16:42:13+00:00","dateAnswered":"2022-10-21T16:29:04+00:00","acceptedAnswers":[{"commentID":348258,"body":"