![]() |
|
#1
|
|||
|
|||
|
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 |