Progress tracker

Hi,
I have been trying to work this out for weeks and I really need some help or guidance please.

I am trying to track my students progress through a qualification.
I will break my requirements down to each section.

All of the criteria in row 1 have to be met on two separate occasions, this will mean a log sheet number being entered in cells in row 4 which is currently showing as a's and b's.
For the criteria in columns B-G, they have to be met by using the criteria in row 2. Not all criteria have to be met twice, so long as the overarching criteria in row 1 is met on two separate occasions and the criteria in row 2 are all used at least once.

My next part is the same requirements, but this time any two from columns H-O must be used.

Finally the same criteria, but this time columns P-AA can be met as stated in row 1.

I would like to be able to enter the results of the sections into a final percentage column.
I was trying to achieve a result for each section of 0,1 or 2 to calculate the percentage progression, but I am happy to go with the best option for this that gets suggested.

This does not have to be one calculation, If multiple cells are required I can hide them for general use.

I have attached a copy of the sample spreadsheet.

I am really hoping that somebody can help out with this, as I am tearing my hair out over this.

Sorry it is not clear, I will try my best to explain a bit clearer.

A and B are just generic items I have used to try to demonstrate that there will be different data in each box.
The cells will have log sheet references which may be different each time this is completed.

Maybe if I explain the end goal, it might be easier to put into the spreadsheet.
So an example of an actual criteria to complete is as follows:-
1.1 - Identify which work location health and safety procedures are relevant to your working environment - This has to be met on two separate occasions using two of the following:-
a confined spaces
b residential
c commercial

So what will be expected that there will be a minimum of two log sheets to meet 1.1 but using at least two of a,b or c

I need a way of checking that there are two different log sheets used and that at least two of a,b or c have been met. These are the criteria in row 2.

Sorry about the merged cells, I don't know a better way of putting heading over multiple rows.

Is this a clearer way of considering my problem.
in the spreadsheet in the original post I would like the following to be worked out:-
Cells B4 to G4 need to be checked to ensure that there are at least two different entries in that range of cells.
There also needs to be a check to see if cells B4, D4 and F4 all contain an entry. The remaining cells may not be fully completed, but they maybe.
Once the rules above have been met, I need to score the outcome. I was thinking 0 for no entries, 1 for log sheet entries that are the same and if all criteria are met i.e. two different log sheets and the required cells completed, then a score of 2 is recorded.

For cells H4 to O4 these need to be checked to ensure that there are at least two different entries in that range of cells.
There then needs to be a check to ensure that two of H4, J4, L4 or N4 have an entry in them.
They would need the same scoring method.

Cells P4 to AA4 need to have two different entries in them.
For this instance cells one of P4, R4, T4, V4, X4 or Z4 must have an entry.

I am not sure if this is a clearer explanation or not.

Thank you for looking at this for me.

Keith

Thank you for your time helping with this.

It won't be A, B or C entered in the cells.
It will be log sheet reference numbers and they are different each time.
They take the form of 00FQ59, but this could be different for each entry.

The CountA formula would work, but it would need another part to it to verify that there at least two different log sheet references in the three.

Thank you, I look forward to your thoughts on how this can be done

etaf - thank you for trying.
I could get them to work individually, but not together.

I appreciate your help.