• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

How to calculate the number of completed audits on a spreadsheet

In a relatively simple spreadsheet (sheet A) I am wanting a formula that will check the table for the number of projects completed by a specific Manager ref (A2:A10) and tell me how many of those are completed, based on the fact that they have a date in the remedial action column (L2:L10).
There are six managers (in individual cells A16, 17, 18, 19, 20 and 21) and the number of completed audits will go in cells B16, 17, 18, 19, 20 and 21).

Thanks in advance
Anthony
 
Hello, and welcome to the forum Anthony.

In B16 put this formula:
=COUNTIFS(A$2:A$10,A16,L$2:L$10,">0")
Copy down to B21, and you're good to go.
 
Back
Top