Check out theFormula Handbook templateto view 100+ formulas, including a glossary of every function and examples of commonly used and advanced formulas.
Formulas and Functions
Discussion List
Help Article Resources
Categories
Popular Tags
- Formulas8,986
- Project Management4,102
- Sheets3,352
- Reports2,308
- 形式2,049
- functionality1,942
- IT & Operations1,688
- Support1,420
- Cell linking1,375
- Enhancement Request1,363
- Email Notifications1,352
- Account and User Management1,347
- Automations1,309
- Integrations1,154
- Construction1,063
- Technology1,041
- Conditional Formatting1,032
- Dashboards900
- Manufacturing852
- Sharing and Collaboration798
- API and Developers745
- Calendar View709
- Product Development708
- Gantt View706
- Update Requests695
I hope you're well and safe!<\/p>
You have to sum them up one by one and add them together.<\/p>
Try something like this.<\/p>
=SUMIFS([No. of Minutes Taken to Complete Job]:[No. of Minutes Taken to Complete Job], [Job Type]:[Job Type], \"CD Creation\") + SUMIFS([No. of Minutes Taken to Complete Job]:[No. of Minutes Taken to Complete Job], [Job Type]:[Job Type], \"CD Extraction\") + SUMIFS([No. of Minutes Taken to Complete Job]:[No. of Minutes Taken to Complete Job], [Job Type]:[Job Type], \"Print & Post\") + SUMIFS([No. of Minutes Taken to Complete Job]:[No. of Minutes Taken to Complete Job], [Job Type]:[Job Type], \"USB Creation\") + SUMIFS([No. of Minutes Taken to Complete Job]:[No. of Minutes Taken to Complete Job], [Job Type]:[Job Type], \"USB Extraction\")<\/p>
Did that work\/help? <\/p>
I hope that helps!<\/p>
Be safe, and have a fantastic week!<\/p>
Best,<\/p>
Andrée Starå<\/strong><\/a> | Workflow Consultant \/ CEO @ WORK BOLD<\/strong><\/a><\/p> ✅Did my post(s) help or answer your question or solve your problem? Please support the Community by <\/em>marking it Insightful\/Vote Up, Awesome, or\/and as the accepted answer<\/em><\/strong>. It will make it easier for others to find a solution or help to answer!<\/em><\/p>"},{"commentID":351643,"body":" @Cheryl Collins<\/a> <\/p> Try this.<\/p> =SUMIFS([No. of Minutes Taken to Complete Job]:[No. of Minutes Taken to Complete Job], [Job Type]:[Job Type], \"CD Creation\", [Date Received]:[Date Received], IFERROR(MONTH(@cell), 0) = MONTH(TODAY())) + SUMIFS([No. of Minutes Taken to Complete Job]:[No. of Minutes Taken to Complete Job], [Job Type]:[Job Type], \"CD Extraction\", [Date Received]:[Date Received], IFERROR(MONTH(@cell), 0) = MONTH(TODAY())) + SUMIFS([No. of Minutes Taken to Complete Job]:[No. of Minutes Taken to Complete Job], [Job Type]:[Job Type], \"Print & Post\", [Date Received]:[Date Received], IFERROR(MONTH(@cell), 0) = MONTH(TODAY())) + SUMIFS([No. of Minutes Taken to Complete Job]:[No. of Minutes Taken to Complete Job], [Job Type]:[Job Type], \"USB Creation\", [Date Received]:[Date Received], IFERROR(MONTH(@cell), 0) = MONTH(TODAY())) + SUMIFS([No. of Minutes Taken to Complete Job]:[No. of Minutes Taken to Complete Job], [Job Type]:[Job Type], \"USB Extraction\", [Date Received]:[Date Received], IFERROR(MONTH(@cell), 0) = MONTH(TODAY()))<\/p> Did that work?<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question","log":{"dateUpdated":"2022-11-17 14:37:03","updateUser":{"userID":125322,"name":"Cheryl Collins","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Cheryl%20Collins","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!ujDUd8trmpQ!HMFV36dbhPo!OB9bg9sjUrN","dateLastActive":"2022-11-18T08:14:14+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":[{"tagID":254,"urlcode":"Formulas","name":"Formulas"}]},{"discussionID":97908,"type":"question","name":"My COUNTIF formula is returning 0 instead of the correct decimal value. What am I doing wrong?","excerpt":"Hi, I am using this formula in a supporting sheet to calculate readiness for a task, but I keep getting zeros no matter what... =COUNTIF({Cross-site IHA Yes}, 1 \/ COUNTIF({Cross-Site IHA Ask 1}, 1)) Essentially this is saying, count all the \"checked\" boxes in column 1 and divide them by the number of boxes \"checked\" in…","categoryID":322,"dateInserted":"2022-11-17T19:16:02+00:00","dateUpdated":null,"dateLastComment":"2022-11-17T19:20:55+00:00","insertUserID":148706,"insertUser":{"userID":148706,"name":"Bradhickswa","url":"https:\/\/community.smartsheet.com\/profile\/Bradhickswa","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!AuHRX9yKuf0!3hlSP6CUF7s!8dWYTxFWd_v","dateLastActive":"2022-11-17T19:23:55+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":148706,"lastUser":{"userID":148706,"name":"Bradhickswa","url":"https:\/\/community.smartsheet.com\/profile\/Bradhickswa","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!AuHRX9yKuf0!3hlSP6CUF7s!8dWYTxFWd_v","dateLastActive":"2022-11-17T19:23:55+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":15,"score":null,"hot":3337426617,"url":"https:\/\/community.smartsheet.com\/discussion\/97908\/my-countif-formula-is-returning-0-instead-of-the-correct-decimal-value-what-am-i-doing-wrong","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/97908\/my-countif-formula-is-returning-0-instead-of-the-correct-decimal-value-what-am-i-doing-wrong","format":"Rich","tagIDs":[254],"lastPost":{"discussionID":97908,"commentID":351599,"name":"Re: My COUNTIF formula is returning 0 instead of the correct decimal value. What am I doing wrong?","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/351599#Comment_351599","dateInserted":"2022-11-17T19:20:55+00:00","insertUserID":148706,"insertUser":{"userID":148706,"name":"Bradhickswa","url":"https:\/\/community.smartsheet.com\/profile\/Bradhickswa","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!AuHRX9yKuf0!3hlSP6CUF7s!8dWYTxFWd_v","dateLastActive":"2022-11-17T19:23:55+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-11-17T19:20:47+00:00","dateAnswered":"2022-11-17T19:17:59+00:00","acceptedAnswers":[{"commentID":351598,"body":"
