Formula to count dates in column C where there are specific values in same row on column A&B only

[Snoochieboochie12]

Hi,

I hope someone can help me; I’m tearing my hair out trying to get this to work.
I am trying to put together a table to measure progress made by a number of individuals to completing their tasks for a given month.
In this summary table I will need to count the number on nonblack cells in a column (Take C as the example) where there is a certain text string on the same row in two other columns (A & B).
i.e. in Count dates in column C where Column A says ‘Dan’ and Column B says ‘June’.
Columns C – F will be populated with VLOOKUP’s, so the formula needs to count ignore the formula and count only the results.

Sheet 1:
Illustrative Table:

	A	B	C	D	E	F	G	F	G
1				Design Submitted	Design Approved	Build Started	Build Completed
2		Dan	June	COUNT	COUNT	COUNT	COUNT
3		Matt	June	COUNT	COUNT	COUNT	COUNT
4		Dan	July	COUNT	COUNT	COUNT	COUNT
5		Matt	July	COUNT	COUNT	COUNT	COUNT
6		Dan	Aug	COUNT	COUNT	COUNT	COUNT
7		Matt	Aug	COUNT	COUNT	COUNT	COUNT
8		Lee	Aug	COUNT	COUNT	COUNT	COUNT

<tbody>
</tbody>

Sheet 2
Data:

	A	B	C	D	E	F	G	H	I
1	Manager	Month	Design Submitted	Design Approved	Build Started	Build Completed
2	Dan	June	12/1/18	12/1/18
3	Matt	June
4	Dan	July	12/1/18	12/1/18	12/1/18
5	Matt	Aug	12/1/18	12/1/18
6	Lee	June	12/1/18	12/1/18	12/1/18	12/1/18
7	Dan	July	12/1/18
8

<tbody>
</tbody>

I ideally need this to work on a table populated with formula results, but could live with converting it all to plain text if I need to.

Any help would be much appreciated! Many thanks

 

[Panda514]

Hello,

I'm not sure why your example shows count for all cells if you said that you only want to count non blank cells.

 

[Fluff]

How about

Excel 2013/2016
	A	B	C	D	E	F
1			Design Submitted	Design Approved	Build Started	Build Completed
2	Dan	June	1	1	0	0
3	Matt	June	0	0	0	0
4	Dan	July	2	1	1	0
5	Matt	July	0	0	0	0
6	Dan	Aug	0	0	0	0
7	Matt	Aug	1	1	0	0
8	Lee	Aug	0	0	0	0
Sheet1

Cell Formulas
Range	Formula
C2	=COUNTIFS(Sheet2!$A$2:$A$7,$A2,Sheet2!$B$2:$B$7,$B2,Sheet2!C$2:C$7,"<>")