Anthony Pinnegar
Member
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
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