Forum Discussion
Calculating which % of users fill out different data points
Hi,
I have a list of users for my company platform and I'm trying to use the data to create stats but I'm not very familiar with excel. For example, I'm trying to understand what percentage of users have actually made a post on the platform. How do I do this?
Example of data:
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.
- mathetesSilver Contributor
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.
- CourtneyR1745Copper ContributorI think this will work! I do want to be able to calculate with the weighted aspect, but that's secondary. Thank you!