| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Count values in array of data where no blanks in one column
Hi,
I am collating project details from multiple sources and need to report back how many projects are active in specific phases based on data such as in the table below: Projects Phase Version "Start Date W/c" "End Date W/c" A Prep Build Deliver a1 5-Apr 26-Apr Close a1 26-Apr 26-Jul B Prep Build Deliver b1 5-Apr 26-Apr Close b1 26-Apr 26-Jul C Prep Build c1 19-Apr 3-May Deliver c1 5-Apr 19-Apr Close c2 3-May 2-Aug D Prep d1 5-Apr 5-Jul Build d1 26-Jul 2-Aug Deliver d1 5-Jul 26-Jul Close d1 2-Aug 1-Nov If the start date has an entry it means that phase is active. In the table above I would need to count how many projects are at the 'Deliver' stage for example. I have tried a few options and the closed I have got is: =COUNTIF(Data1!B3:D18,"deliver") however this also counts cells which contain a null value, Could anyone help please? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count Blanks bw Data | Excel Discussion (Misc queries) | |||
| Count cells w/values in column if the data in column a matches cri | Excel Worksheet Functions | |||
| Counting multiple values (including blanks) in one column | Excel Discussion (Misc queries) | |||
| Count Non-Blanks in one column based on criteria in another | Excel Worksheet Functions | |||
| Count Blanks in a Filtered Column | Excel Worksheet Functions | |||
Threaded Mode
