When I enter an employee ID, Excel will automatically tell me the employee's name (using the VLOOKUP function), the total number of weeks of data we have (using the COUNTIF function), and the ...

However, if you have only ten or twenty rows, you can use this formula to get your job done. Read: How to count Nonblank Cells in Excel. When he is not writing about Microsoft Windows or Office ...