Hi everyone,

A big thank you for everyone who contributed to the problem I had with the attached Worksheet last week I couldn’t have done it without you

As my experience is limited in Excel please could someone help with the following problem?

As you will see I have attached a draft version of a staff training Matrix. Towards the bottom of the worksheet I'm counting how many staff members have completed the said course, using this formula to count staff members:

=SUMPRODUCT(--(D6:D16>=TODAY()-1095))

Once 1 or more years have past the cell will go red to indicate the staff member is now out of date. The problem I didn’t realise at the time is that not all staff members will need to complete the said course due to their grade. I still want to use this formula but I also want it to acknowledge cells that contain the wording "N/A" are not to be counted.

I assume this can be done?