Forum Discussion
Calculating which % of users fill out different data points
Does this work for you? I'm sure there are different ways (there always are in Excel), but COUNTIF and COUNTA are two useful functions. This uses those two to get the result which I then format as percentage. The actual spreadsheet is attached.
The COUNTIF formula counts how many have posted more than zero times; the COUNTA counts users. The former is divided by the latter, to get 67%
Now, if you want percentage to take into account that one person has posted 10/12ths of the posting, that's a different formula and pretty different from what you asked. So you may need to be more precise on whether you meant the simpler calculation on the one that attends to weight or extent of usage.
Does this work for you? I'm sure there are different ways (there always are in Excel), but COUNTIF and COUNTA are two useful functions. This uses those two to get the result which I then format as percentage. The actual spreadsheet is attached.
The COUNTIF formula counts how many have posted more than zero times; the COUNTA counts users. The former is divided by the latter, to get 67%
Now, if you want percentage to take into account that one person has posted 10/12ths of the posting, that's a different formula and pretty different from what you asked. So you may need to be more precise on whether you meant the simpler calculation on the one that attends to weight or extent of usage.
- I think this will work! I do want to be able to calculate with the weighted aspect, but that's secondary. Thank you!
