Help with Check List

[Mike75]

I have a two part check list. Section and Area.

I am using the formula
=SUM(IF(FREQUENCY(MATCH(Table1[Section],Table1[Section],0),MATCH(Table1[Section],Table1[Section],0))>0,1))
to tell me how many different Sections there are.

and =COUNTIFS(Table1[Area],"*") to tell me how many Areas there are.

I am using =COUNTIFS(Table1[Area],"*",Table1[Finish],"*")
to tell me how many Areas I have completed

I need help trying to write a formula to tell me how many areas are completed.

There are 3 area per section. Here what the checklist looks like I color code the formula to where I have them in the spreadsheet.
The ??? is what I need help with. The are 3 sections that re completed.


[TABLE="width: 742"]
<tbody>[TR]
[TD]Finish[/TD]
[TD]Section[/TD]
[TD]Area[/TD]
[TD][/TD]
[TD][/TD]
[TD]Total[/TD]
[TD]Finish[/TD]
[/TR]
[TR]
[TD]yes[/TD]
[TD]A[/TD]
[TD]A[/TD]
[TD][/TD]
[TD]Section[/TD]
[TD]8[/TD]
[TD] ???[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD][/TD]
[TD]Area[/TD]
[TD]24[/TD]
[TD]19[/TD]
[/TR]
[TR]
[TD]yes[/TD]
[TD]A[/TD]
[TD]C[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]yes[/TD]
[TD]B[/TD]
[TD]D[/TD]
[TD][/TD]
[TD]Section[/TD]
[TD]Finish[/TD]
[TD]Still[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]B[/TD]
[TD]E[/TD]
[TD][/TD]
[TD]A[/TD]
[TD]2[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]yes[/TD]
[TD]B[/TD]
[TD]F[/TD]
[TD][/TD]
[TD]B[/TD]
[TD]2[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]yes[/TD]
[TD]C[/TD]
[TD]G[/TD]
[TD][/TD]
[TD]C[/TD]
[TD]2[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]yes[/TD]
[TD]C[/TD]
[TD]H[/TD]
[TD][/TD]
[TD]D[/TD]
[TD]3[/TD]
[TD]Done[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]C[/TD]
[TD]I[/TD]
[TD][/TD]
[TD]E[/TD]
[TD]2[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]yes[/TD]
[TD]D[/TD]
[TD]J[/TD]
[TD][/TD]
[TD]F[/TD]
[TD]3[/TD]
[TD]Done[/TD]
[/TR]
[TR]
[TD]yes[/TD]
[TD]D[/TD]
[TD]K[/TD]
[TD][/TD]
[TD]G[/TD]
[TD]2[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]yes[/TD]
[TD]D[/TD]
[TD]L[/TD]
[TD][/TD]
[TD]H[/TD]
[TD]3[/TD]
[TD]Done[/TD]
[/TR]
[TR]
[TD]yes[/TD]
[TD]E[/TD]
[TD]M[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]E[/TD]
[TD]N[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]yes[/TD]
[TD]E[/TD]
[TD]O[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]yes[/TD]
[TD]F[/TD]
[TD]P[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]yes[/TD]
[TD]F[/TD]
[TD]Q[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]yes[/TD]
[TD]F[/TD]
[TD]R[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]yes[/TD]
[TD]G[/TD]
[TD]S[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]G[/TD]
[TD]T[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]yes[/TD]
[TD]G[/TD]
[TD]U[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]yes[/TD]
[TD]H[/TD]
[TD]V[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]yes[/TD]
[TD]H[/TD]
[TD]W[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]yes[/TD]
[TD]H[/TD]
[TD]X[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[oldbrewer]

there are 3 areas per section - what does this mean

can you make the data smaller to clarify what you want

are some letters really numbers ?