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 ... 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. ... Copied to Clipboard!
|
argonautweakend 04/02/21 11:33:55 PM #3: |
seems legit i'll look into it.
... Copied to Clipboard!
|
Topic List |
Page List:
1 |