Discussions
3)\/COUNT(B:B)] but can't figure out how to add the filter for the period (it's a \"Month\" column). =IF(Month:Month=7(COUNTIF(A:A,\">3\")\/(COUNT(B:B),\"\") does not work…","categoryID":322,"dateInserted":"2023-06-24T14:05:07+00:00","dateUpdated":null,"dateLastComment":"2023-07-18T14:15:42+00:00","insertUserID":149226,"insertUser":{"userID":149226,"name":"Ldonoghue","url":"https:\/\/community.smartsheet.com\/profile\/Ldonoghue","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!!28lBP6L25To!knnAvx7mcjw!0bjLA8JaVC7","dateLastActive":"2023-07-19T18:35:23+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"updateUserID":null,"lastUserID":149226,"lastUser":{"userID":149226,"name":"Ldonoghue","url":"https:\/\/community.smartsheet.com\/profile\/Ldonoghue","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!!28lBP6L25To!knnAvx7mcjw!0bjLA8JaVC7","dateLastActive":"2023-07-19T18:35:23+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":14,"countViews":128,"score":null,"hot":3377313649,"url":"https:\/\/community.smartsheet.com\/discussion\/106866\/need-help-with-a-formula","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/106866\/need-help-with-a-formula","format":"Rich","groupID":null,"statusID":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2023-06-24T21:10:00+00:00","acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":[]},"tags":[{"tagID":254,"urlcode":"formulas","name":"Formulas"}],"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}]},{"discussionID":92386,"type":"question","name":"How to average non-adjacent cells","excerpt":"I'm trying to average non-adjacent ranges. I've tried =AVERAGEIF([Range:Range],[Range:Range],\"<>0\"), but get an error each time.","categoryID":322,"dateInserted":"2022-06-20T15:42:47+00:00","dateUpdated":"2022-06-20T15:45:51+00:00","dateLastComment":"2023-06-01T16:44:31+00:00","insertUserID":149226,"insertUser":{"userID":149226,"name":"Ldonoghue","url":"https:\/\/community.smartsheet.com\/profile\/Ldonoghue","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!!28lBP6L25To!knnAvx7mcjw!0bjLA8JaVC7","dateLastActive":"2023-07-19T18:35:23+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"updateUserID":91566,"lastUserID":151992,"lastUser":{"userID":151992,"name":"jcouncil","url":"https:\/\/community.smartsheet.com\/profile\/jcouncil","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!nYHQP9xXEv4!00NXvxNFeXw!brwM3-qthaq","dateLastActive":"2023-08-21T21:22:00+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":8,"countViews":202,"score":null,"hot":3341382438,"url":"https:\/\/community.smartsheet.com\/discussion\/92386\/how-to-average-non-adjacent-cells","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/92386\/how-to-average-non-adjacent-cells","format":"Rich","groupID":null,"statusID":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2022-06-20T17:10:58+00:00","acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":[]},"tags":[],"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}]}],"title":null,"subtitle":null,"description":null,"viewAllUrl":null,"isMainContent":false,"noCheckboxes":true}">