Excel formula help

Closed
computers for dummies - NOT - Feb 10, 2010 at 12:18 PM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Feb 10, 2010 at 02:11 PM
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 response

rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Feb 10, 2010 at 02:11 PM
May be you want to use SUMIF and COUNTIF formulas ?
0