Excel formula help [Closed]

Report
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
Hello,
I want to add a column of numbers (only cells that contain data, there will be some that will be blank and then I want to get the percentage of that number. For instance, I have 12 people that need training and I want to record when they have completed their training - but I want to be able to tell at a glance what percentage of those 12 people have complied with the training. Hope this make sense

1 reply

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
767
May be you want to use SUMIF and COUNTIF formulas ?

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!