View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Greenwich_Man Greenwich_Man is offline
external usenet poster
 
Posts: 3
Default Counting Staffs Reports


I have a spreadsheet that shows when certain professionals need to
submit a report by.

In column J I have a nested IF that will show if the report was
completed on time or not, or if it's still yet to be done, etc. This
column shows "On Time", "Not on Time", "Not Yet Done" etc.

In column G I have the name of the professional.

I want to count how many each professional has where "On Time" is the
result.

Any help would be gratefully received, and thanks in advance

Paul