I know someone is going to show me a very easy way to do this but for some reason I can't figure this out. I have a large spreadsheet of department projects worked on by various people. The last two columns are NAME and COMPLETION DATE. I need a formula to figure completion percentages based on each person. I have used =COUNTIF(AE:AE,"JOHN") to figure the total for each person. I need a formula to count each "COMPLETION DATE" cell for an individuals name that is filled. Any help would be greatly apprecaited.