多重标准相加

Karrie戴维斯
Karrie戴维斯 优等生
编辑12/09/19 公式和函数

你好,

我可以算出本周的总价,但我想添加另一个标准。我总是出错,有人能帮忙吗

=条件求和({星期数},@cell= (WEEKNUMBER(TODAY())),{容量},{工作类型},@cell =“预算”)

谢谢

评论

帮助文章参考资料欧宝体育app官方888

想要直接在智能表中练习使用公式吗?

请查看公式手册模板!
Try this: =COUNTIF({Product Backlog - Q360 Range 2}, FIND(\"Dave Hoffmeister\", @cell) >= 1)<\/p>

or this if you want to point to the name in the contact list without typing each:<\/p>

=COUNTIF({Product Backlog - Q360 Range 2}, FIND([Insert Contact Column Name]@row, @cell) >= 1)<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"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":106391,"type":"question","name":"Index formula versus If And","excerpt":"Hi, First time posting. I have several sheets I link together. Long story short is web applications pasted into one sheet populate into another for vetting for eligibility of employment. That sheet will then provide the data for my drop downs into the Active Sheet which will pull the corresponding rows of data based on the…","categoryID":322,"dateInserted":"2023-06-13T19:26:31+00:00","dateUpdated":"2023-06-14T09:06:24+00:00","dateLastComment":"2023-06-14T14:38:38+00:00","insertUserID":162337,"insertUser":{"userID":162337,"name":"maineL","title":"Admin. & Course Coordinator","url":"https:\/\/community.smartsheet.com\/profile\/maineL","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!plNXqQdBs_o!2kvQ_7y42f4!PTHvB33mICN","dateLastActive":"2023-06-14T14:54:40+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":91566,"lastUserID":162337,"lastUser":{"userID":162337,"name":"maineL","title":"Admin. & Course Coordinator","url":"https:\/\/community.smartsheet.com\/profile\/maineL","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!plNXqQdBs_o!2kvQ_7y42f4!PTHvB33mICN","dateLastActive":"2023-06-14T14:54:40+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":6,"countViews":55,"score":null,"hot":3373441509,"url":"https:\/\/community.smartsheet.com\/discussion\/106391\/index-formula-versus-if-and","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/106391\/index-formula-versus-if-and","format":"Rich","lastPost":{"discussionID":106391,"commentID":380504,"name":"Re: Index formula versus If And","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/380504#Comment_380504","dateInserted":"2023-06-14T14:38:38+00:00","insertUserID":162337,"insertUser":{"userID":162337,"name":"maineL","title":"Admin. & Course Coordinator","url":"https:\/\/community.smartsheet.com\/profile\/maineL","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!plNXqQdBs_o!2kvQ_7y42f4!PTHvB33mICN","dateLastActive":"2023-06-14T14:54:40+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,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/K0XF0S5N57N6\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2023-06-14T14:55:00+00:00","dateAnswered":"2023-06-14T14:09:19+00:00","acceptedAnswers":[{"commentID":380493,"body":"

Right. You'll need to change the very first \"S\" to an \"F\" in the Fall column.<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"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":106366,"type":"question","name":"Array formulas for project completion in Smartsheet","excerpt":"Hello, I have a project plan in Smartsheet with 2 columns: % Complete Relative weight of completion This cells are used in parent rows (the phases of the project) and are used to indicate the completion of a phase but also the relative amount of effort that each phase has (as an average is not accurate enough) I would like…","categoryID":322,"dateInserted":"2023-06-13T12:58:24+00:00","dateUpdated":"2023-06-13T12:59:17+00:00","dateLastComment":"2023-06-13T17:47:52+00:00","insertUserID":162323,"insertUser":{"userID":162323,"name":"Ignacio de la Llave","url":"https:\/\/community.smartsheet.com\/profile\/Ignacio%20de%20la%20Llave","photoUrl":"https:\/\/lh3.googleusercontent.com\/a\/AAcHTtdcDDZaqcn-zSRDvB-hN8rvWiw8lpzQElqnGMtp=s96-c","dateLastActive":"2023-06-14T09:49:03+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":91566,"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":"2023-06-14T14:08:37+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":37,"score":null,"hot":3373341376,"url":"https:\/\/community.smartsheet.com\/discussion\/106366\/array-formulas-for-project-completion-in-smartsheet","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/106366\/array-formulas-for-project-completion-in-smartsheet","format":"Rich","tagIDs":[254],"lastPost":{"discussionID":106366,"commentID":380352,"name":"Re: Array formulas for project completion in Smartsheet","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/380352#Comment_380352","dateInserted":"2023-06-13T17:47:52+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":"2023-06-14T14:08:37+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,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/ZMII8W5L8DT9\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2023-06-13T15:57:54+00:00","dateAnswered":"2023-06-13T15:47:01+00:00","acceptedAnswers":[{"commentID":380323,"body":"

I would suggest a helper column (can be hidden after setting up) that determines the weighted % on each parent row.<\/p>

=IF([Weight (% of Completion]@row <> \"\", [Weight (% of Completion]@row * [% Complete]@row)<\/p>


<\/p>

Then to add each piece together, you would use<\/p>

=SUM(CHILDREN([Helper Column]@row))<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"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":[{"tagID":254,"urlcode":"Formulas","name":"Formulas"}]}],"initialPaging":{"nextURL":"https:\/\/community.smartsheet.com\/api\/v2\/discussions?page=2&categoryID=322&includeChildCategories=1&type%5B0%5D=Question&excludeHiddenCategories=1&sort=-hot&limit=3&expand%5B0%5D=all&expand%5B1%5D=-body&expand%5B2%5D=insertUser&expand%5B3%5D=lastUser&status=accepted","prevURL":null,"currentPage":1,"total":9983,"limit":3},"title":"Trending in Formulas and Functions ","subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}">

公式和函数趋势