Help with Check List

RedOdin · #1 07-27-2018, 06:59 PM

In F2 I am using =SUM(IF(FREQUENCY(MATCH(Table1[Section],Table1[Section],0),MATCH(Table1[Section],Table1[Section],0))>0,1)) to tell me the Total number of Sections I have.

In F3 =COUNTIFS(Table1[Area],"*") to tell me the Total number of Areas I have.
In G3 =COUNTIFS(Table1[Area],"*",Table1[Finish],"*") tells me how many Areas are Finish.
I am trying to write a formula in G2 that will tell me how many Finish Sections there are.

I made a breakdown table below the count table and you can see there are 3 Sections that are done.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Excel vba to check to check if two columns are empty	subspace3	Excel Programming	5	07-09-2015 04:45 PM
Check for duplicated data and print list	cjharley	Excel	2	12-19-2014 11:44 PM
cannot check/uncheck check box but added check box	learn2office	Word	1	11-27-2012 02:02 AM
Check which ListGalleries a list belongs to?	tinfanide	Word VBA	5	06-29-2012 07:47 AM
Link word check box to access check box	Mrkieth	Word	4	01-30-2012 06:43 AM