Counting Staffs Reports

[Greenwich_Man]

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

 

[Bernard Liengme]

The 'nice' way would be a Pivot Table - see one or more of these
http://www.cpearson.com/excel/pivots.htm
http://peltiertech.com/Excel/Pivots/pivotstart.htm
http://www.contextures.com/xlPivot02.html
http://www.ozgrid.com/Excel/excel-pivot-tables.htm
http://www.techonthenet.com/excel/pivottbls/index.htm
http://www.dicks-blog.com/archives/2005/06/23/download-pivottable-parameters/

But you could use SUMPRODUCT.
I will assume the G column has 100 entries (adjust the formula as needed),
beginning in G1
Let L1:L10 contain a list of the staff (each name appearing only once - make
this using a filter on G and copying the unique records)
In M1 enter =SUMPRODUCT(--($G$1:$G$100=L1),--(J1:J100="On Time"))
Copy this down to
For more on SUMPRODUCT see
http://www.xldynamic.com/source/xld.SUMPRODUCT.html
http://mcgimpsey.com/excel/formulae/doubleneg.html
best wishes