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:
[TABLE="width: 500"]
<tbody>[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[TD]E[/TD]
[TD]F[/TD]
[TD]G[/TD]
[TD]F[/TD]
[TD]G[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Design Submitted[/TD]
[TD]Design Approved[/TD]
[TD]Build Started[/TD]
[TD]Build Completed[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD][/TD]
[TD]Dan[/TD]
[TD]June[/TD]
[TD]COUNT[/TD]
[TD]COUNT[/TD]
[TD]COUNT[/TD]
[TD]COUNT[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD][/TD]
[TD]Matt[/TD]
[TD]June[/TD]
[TD]COUNT[/TD]
[TD]COUNT[/TD]
[TD]COUNT[/TD]
[TD]COUNT[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD][/TD]
[TD]Dan [/TD]
[TD]July[/TD]
[TD]COUNT[/TD]
[TD]COUNT[/TD]
[TD]COUNT[/TD]
[TD]COUNT[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD][/TD]
[TD]Matt[/TD]
[TD]July[/TD]
[TD]COUNT[/TD]
[TD]COUNT[/TD]
[TD]COUNT[/TD]
[TD]COUNT[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]6[/TD]
[TD][/TD]
[TD]Dan[/TD]
[TD]Aug[/TD]
[TD]COUNT[/TD]
[TD]COUNT[/TD]
[TD]COUNT[/TD]
[TD]COUNT[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]7[/TD]
[TD][/TD]
[TD]Matt[/TD]
[TD]Aug[/TD]
[TD]COUNT[/TD]
[TD]COUNT[/TD]
[TD]COUNT[/TD]
[TD]COUNT[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]8[/TD]
[TD][/TD]
[TD]Lee[/TD]
[TD]Aug[/TD]
[TD]COUNT[/TD]
[TD]COUNT[/TD]
[TD]COUNT[/TD]
[TD]COUNT[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]



Sheet 2
Data:
[TABLE="width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[TD]E[/TD]
[TD]F[/TD]
[TD]G[/TD]
[TD]H[/TD]
[TD]I[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]Manager[/TD]
[TD]Month[/TD]
[TD]Design Submitted[/TD]
[TD]Design Approved[/TD]
[TD]Build Started[/TD]
[TD]Build Completed[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]Dan[/TD]
[TD]June[/TD]
[TD]12/1/18[/TD]
[TD]12/1/18[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]Matt[/TD]
[TD]June[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]Dan[/TD]
[TD]July[/TD]
[TD]12/1/18[/TD]
[TD]12/1/18[/TD]
[TD]12/1/18[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]Matt[/TD]
[TD]Aug[/TD]
[TD]12/1/18[/TD]
[TD]12/1/18[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]6[/TD]
[TD]Lee[/TD]
[TD]June[/TD]
[TD]12/1/18[/TD]
[TD]12/1/18[/TD]
[TD]12/1/18[/TD]
[TD]12/1/18[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]7[/TD]
[TD]Dan[/TD]
[TD]July[/TD]
[TD]12/1/18[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]8[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]

[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]


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,"<>")