Counting cells under finite parameters, excel 2010

[lawitcher1]

I have a file that I am using for a Ham Radio specialized contest. The rules for this contest are:

You get 3 points for each valid CW contact, and 2 points for each valid Phone contact. You can work a station once per band and once per mode.
Out of CA stations only get credit for working CA stations. CA stations get credit for working anyone - hence, DX contacts only count for CA stations.

There are 58 multiples possible, no matter where you are located. 50 states & 8 Canadian Provinces, including California (for inside CA stations), and 58 counties (for out of CA stations).

For the contact to be valid, you must log all the exchange info correctly, including the county, even if you are a CA station.

So, if you worked 10 CW stations, and 10 phone stations, each as a new multiple, then your score would be > (10x3 + 10x2) x 20 = 1,000 pts.

On the attached file:

1) The count in cell A4 should be 8 because line 13 is a duplication of line 12 (compare A13 & A12 along with E12 & E13) Line 13 is not counted by 1 (a contact from line 13, cell A13) and line 16 is duplicated by line 15 (A16 & A15) (is not counted by 1 for a duplicate contact (line 16).

2) The count in cell E5 should be 19 because line 13 is a duplication of line 12 (E13 & E 12) (not counted by 2 for a PH contact from line 13 E13) and line 16 is duplicated by line 15 (E16 & E15) (not counted by 3 for a CW contact line 16, E16).

3) The count in cell L5 should be 2, and cells L12, & L15 should be counted & colored grey, they are not duplicates under the rules as stated above, whereas line 12 is duplicated by line 13 (compare cells C12 & E12) with (C13 & E13), and line 15 is duplicated by line 16 (compare cells C15 & E15) with (C16 & E16)

4) The count in cell M5 should be 6, and cells M7, M8, M9, M10, M14 & M15 should be counted & colored grey, they are not duplicates under the rules as stated above, whereas line 15 is duplicated by line 16 (compare cells C15 & E15) with (C16 & E16).

I need help with this very convoluted formula. Please see the attached file for existing codes and examples.