How do I COUNTIFS with only certain header criteria and also by date??

[LaurenHancy]

Hi All,

I need your expertise.

I need to count and sum a range of data which only is referenced to the column name. I need to create a timesheet and I want to create an automatic invoice with a few drop downs. This part I think i can do on my own i just need help with the formulas.

So just to be clear I want to count (greater than o), sum if the criteria matches a name and a month in a drop down.

Hope you can help me. Thank you x

Date	Month	Oliver	Monica	Pip	William
03/01/17	Jan	6.5	5	3	9
04/01/17	Jan	6.5	5	3	7
05/01/17	Jan	7	5	3	9
06/01/17	Jan	6.5	6	3	6
09/01/17	Jan	6.5	5	3	9
10/01/17	Jan	6.5	5	3	6
11/01/17	Jan	6.5	5	3	9
12/01/17	Jan	7	5	3	6
13/01/17	Jan	6.5	5	3	9
16/01/17	Jan	6.5	5	3	7
17/01/17	Jan	6.5	5	3	9
18/01/17	Jan	6.5	5	3	6
19/01/17	Jan	7	5	3	9
20/01/17	Jan	6.5	5	3	6
23/01/17	Jan	6.5	5	3	9
24/01/17	Jan	6.5	0	3	6
25/01/17	Jan	6.5	0	3	9
26/01/17	Jan	7	0	3	7
27/01/17	Jan	6.5	0	3	9
30/01/17	Jan	6.5	0	3	6
31/01/17	Jan	6.5	0	3	9
01/02/17	Feb	6.5	0	3	9
02/02/17	Feb	7	0	3	7
03/02/17	Feb	6.5	0	3	9
06/02/17	Feb	6.5	0	3	6
07/02/17	Feb	6.5	0	3	9
08/02/17	Feb	6.5	0	3	6
09/02/17	Feb	7	0	3	9
10/02/17	Feb	6.5	0	3	6
13/02/17	Feb	6.5	0	3	9
14/02/17	Feb	6.5	0	3	7
15/02/17	Feb	6.5	5	3	9
16/02/17	Feb	7	0	3	6
17/02/17	Feb	6.5	0	3	9
20/02/17	Feb	6.5	0	3	6
21/02/17	Feb	6.5	5	3	9
22/02/17	Feb	6.5	0	3	6
23/02/17	Feb	7	0	3	9

<!--StartFragment--> <colgroup><col width="65" span="6" style="width:65pt"> </colgroup><tbody>
<!--EndFragment--></tbody>

 

[LaurenHancy]

It works but only brings back "0"

 

[LaurenHancy]

Ok so i have managed to fine a count formula but I am unsure how to add the month into the criteria?

=COUNTIF(INDEX(Sheet1!D5:O264,0,MATCH(I6,Sheet1!D3:O3,0)),">0")

 

[Tetra201]

Maybe

=COUNTIFS(Sheet1!C5:C264,"Jan",INDEX(Sheet1!D5:O264,0,MATCH(I6,Sheet1!D3:O3,0)),">0")