Countifs and exclude criteria
I am trying to count how many people are requesting computers only. I would like to exclude the people that are requesting a computer and internet. I have the formula for the total number computers requested =COUNTIFS(, {Computer Only}, "Computer") but not how to not count the ones that have internet. Can anyone help?
Best Answer
-
David Joyeuse ✭✭✭✭✭Hi@Lee M
It depends on what you show in the [*Approved *Internet] column. If it displays nothing when people are not requesting it then your formula should be:
=COUNTIFS({Computer Only}, "Computer", {No Internet}, ISBLANK(@cell))
Otherwise it would be:
=COUNTIFS({Computer Only}, "Computer", {No Internet}, "Insert No Internet Value here")
Answers
-
David Joyeuse ✭✭✭✭✭
Hi@Lee M
It depends on what you show in the [*Approved *Internet] column. If it displays nothing when people are not requesting it then your formula should be:
=COUNTIFS({Computer Only}, "Computer", {No Internet}, ISBLANK(@cell))
Otherwise it would be:
=COUNTIFS({Computer Only}, "Computer", {No Internet}, "Insert No Internet Value here")
-
Lee M ✭Thank you David! The first formula worked perfectly.
Help Article Resources
Categories
Try wrapping it in a VALUE function.<\/p>
=VALUE(<\/strong>original_formula)<\/strong><\/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":109184,"type":"question","name":"If and Match Formula Help","excerpt":"Hello - I have 2 sheets. One that shows all the fields from our on-prem environment and another that shows all the fields that were migrated to our sandbox via a migration tool. I want to know if any fields were not migrated from our on-prem environment to the sandbox. Any suggestions on an equation to use? I tried the…","snippet":"Hello - I have 2 sheets. One that shows all the fields from our on-prem environment and another that shows all the fields that were migrated to our sandbox via a migration tool. I…","categoryID":322,"dateInserted":"2023-08-20T19:17:19+00:00","dateUpdated":"2023-08-21T08:42:53+00:00","dateLastComment":"2023-08-21T13:43:25+00:00","insertUserID":145541,"insertUser":{"userID":145541,"name":"Melissa Larkin","url":"https:\/\/community.smartsheet.com\/profile\/Melissa%20Larkin","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-08-21T13:40:37+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"updateUserID":91566,"lastUserID":91566,"lastUser":{"userID":91566,"name":"Genevieve P.","title":"Community Manager","url":"https:\/\/community.smartsheet.com\/profile\/Genevieve%20P.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/KHY4Y67W0VRX\/nF76D5N9MFB28.png","dateLastActive":"2023-08-21T16:31:48+00:00","banned":0,"punished":0,"private":false,"label":"Employee Admin"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":32,"score":null,"hot":3385186244,"url":"https:\/\/community.smartsheet.com\/discussion\/109184\/if-and-match-formula-help","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/109184\/if-and-match-formula-help","format":"Rich","lastPost":{"discussionID":109184,"commentID":391600,"name":"Re: If and Match Formula Help","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/391600#Comment_391600","dateInserted":"2023-08-21T13:43:25+00:00","insertUserID":91566,"insertUser":{"userID":91566,"name":"Genevieve P.","title":"Community Manager","url":"https:\/\/community.smartsheet.com\/profile\/Genevieve%20P.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/KHY4Y67W0VRX\/nF76D5N9MFB28.png","dateLastActive":"2023-08-21T16:31:48+00:00","banned":0,"punished":0,"private":false,"label":"Employee Admin"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Get Help","url":"https:\/\/community.smartsheet.com\/categories\/get-help"},{"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\/QC7F1X0I1XUP\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2023-08-21T13:42:50+00:00","dateAnswered":"2023-08-21T12:58:43+00:00","acceptedAnswers":[{"commentID":391588,"body":"
