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.

Finish	Section	Area			Total	Finish
yes	A	A		Section	8	???
	A	B		Area	24	19
yes	A	C
yes	B	D		Section	Finish	Still
	B	E		A	2	1
yes	B	F		B	2	1
yes	C	G		C	2	1
yes	C	H		D	3	Done
	C	I		E	2	1
yes	D	J		F	3	Done
yes	D	K		G	2	1
yes	D	L		H	3	Done
yes	E	M
	E	N
yes	E	O
yes	F	P
yes	F	Q
yes	F	R
yes	G	S
	G	T
yes	G	U
yes	H	V
yes	H	W
yes	H	X

<tbody>
</tbody>

 

[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 ?