Countifs or Pivot table

[waqasbutt]

Hello All,

Need your help, I am trying to use countifs function to get the results (refer below second table) but countif does not works.
I want to count how many issues in a month and results as well. As each month, different issues occurs and I want month count.

I tried Pivot table but there are two issues:

First, if I ungroup it combine months results e.g Dec 18 has 10 records and Dec 19 has 5, it shows me 15.
Second if I do not ungroup them it shows me records with respective months but for results column I only need records with Pass. E.g in same pivot table, I need total records for issues but for results only having Pass. I need this for graph where record will be bar and results will be trend line (ideally I need %).

I tried countifs because it is much flexible where I can search based on specific column and but somehow it does not works.

Any help will be appreciated.

DATA
-----

Item	Date	Results
Issue1	15/12/2019 17:49:57	Pass
Issue2	15/12/2019 17:49:57	Pass
Issue3	14/01/2019 18:41:36	Pass
Issue4	14/01/2019 19:36:39	FAIL
Issue5	15/01/2019 9:18:06	Pass
Issue6	15/01/2019 9:37:55	Pass
Issue7	15/01/2019 9:53:06	Pass
Issue8	15/02/2019 9:51:50	Pass
Issue9	15/03/2019 11:51:52	Pass
Issue10	15/03/2019 11:59:55	Pass
Issue11	15/04/2019 12:27:17	Pass
Issue12	15/05/2019 9:08:04	FAIL
Issue13	15/06/2019 9:13:19	FAIL
Issue14	15/12/2018 9:31:44	Pass
Issue15	15/12/2018 9:31:44	Pass

Results I am looking for;

Month	Issues	Results (ONLY PASS)
Dec-18	2	2
Jan-19	5	4
Feb-19	1	1
Mar-19	2	2
Apr-19	1	1
May-19	1	0
Jun-19	1	0
Dec-19	2	2

Regards,
Waqas

 

[waqasbutt]

yes, sure. thank you again for the help.

 

[waqasbutt]

yes, sure. thank you again for the help.

 

[DanteAmor]

I'm glad to help you. Thanks for the feedback.