|
|
#1
10-05-2015, 01:09 AM
|
|||
|
|||
COUNTA and IF? Possibly
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.
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 CountA function to Count Blanks
|
Alaska1 | Excel | 10 | 02-11-2015 04:20 PM |
|
Is it possibly to lock a table ?
|
spookiepower | Word | 2 | 09-07-2013 08:55 AM |
| COUNTA function returns incorrect value | joeller | Excel | 2 | 10-16-2012 05:37 AM |
| Advanced ToC problem (possibly) | norby | Word | 4 | 05-08-2012 12:02 AM |
| Possibly a VLookup | mrswarrick | Excel | 3 | 01-13-2012 11:12 AM |
Windows 7 64bit 
Office 2007
Threaded Mode