Poll of the Day > how do i do this in google sheets

Topic List	Page List: 1
argonautweakend 04/02/21 11:25:16 PM #1:	percent of cells that have any number other than zero: how do i automate this figure. I have a checklist. If it has a zero, I dont have it. If it has a number, I do. How can I make it so that I can track the % of items a checklist I have in my collection by figuring out how many cells have a figure other than zero out of all cells <cite>argonautweakend posted [p:952409237] in how do i d... [t:79384525]...</cite> <quote>percent of cells that have any number other than zero: how do i automate this figure. I have a checklist. If it has a zero, I dont have it. If it has a number, I do. How can I make it so that I can track the % of items a checklist I have in my collection by figuring out how many cells have a figure other than zero out of all cells </quote> ... Copied to Clipboard!
Zeus 04/02/21 11:32:53 PM #2:	Probably by doing a sumif or countif function? Not sure if those work the same in Google sheets as other spreadsheets since a lot of them have minor variations to avoid lawsuits. It kinda depends what you're really trying to figure out. If it's just a matter of having anything at all, then you'd go with a countif. --- (\/)(\/)\|-\| There are precious few at ease / With moral ambiguities / So we act as though they don't exist. <cite>Zeus posted [p:952409440] in how do i d... [t:79384525]...</cite> <quote>Probably by doing a sumif or countif function? Not sure if those work the same in Google sheets as other spreadsheets since a lot of them have minor variations to avoid lawsuits. It kinda depends what you're really trying to figure out. If it's just a matter of having anything at all, then you'd go with a countif. </quote> ... Copied to Clipboard!
argonautweakend 04/02/21 11:33:55 PM #3:	seems legit i'll look into it. <cite>argonautweakend posted [p:952409472] in how do i d... [t:79384525]...</cite> <quote>seems legit i'll look into it. </quote> ... Copied to Clipboard!
Topic List	Page List: 1