average/percentage
if you look at the spreadsheet, you will see I have 10 criterias either compliant or non-compliant. I want to convert the compliant criteria to a percentage. the percentage should show up in cell "Monthly Compliance". The percentage should change if Compliancy changes. Appreciate any help I can get or if you can make the spreadsheet better please feel free in sending me your ideas. Thanks.
JR
Hi JR,
to calculate the percentage of the compliant criteria, you need to count the compliant rows and divide this number with the total number of rows.
If you want to include only rows with entries in column A, your row count can be done with the formula
=COUNTA(A5:A34)
This function will count only cells with a value in them, text or number. You can count the number of compliant rows with the formula
=COUNTIF(K5:K34,"compliant")
This function will count only the cells that have the word "compliant"
Now you can either calculate the percentage in a different cell, or you can combine the functions into one formula like this:
Percentage of compliance
=COUNTIF(K5:K34,"compliant")/COUNTA(A5:A34)
format the result as a percentage and you're done.
HTH
Thanks formula works great.
Jr
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks