Hello - I found this site essentially by the title of this thread. It got me close - but not quite. I am trying something simpler.
I have a task list and one column is called Completed (yes/no) and the total number of cells in that column is 182. I need to figure out how to list the total % complete.
So far, I used =COUNTIF(C2:C182,"Yes") to get me the total number of completes - that works and gives me 117. I just need to finish the formula to give the correct completion percentage.
Any suggestions?
Thank You!
Bookmarks