Count values by conditions from an array

[darzu]

Hello,

i got an export from a ticketing system and i want to carry out some data (want to create kpi dashboard) and i woul need the date in this format

Book1
	K	L	M	N	O
12	Volume	2020	January	Feb	Mar
13	High	678	12	333	333
14	Medium	368	2	333	33
15	Low	377	11	33	333
16	Total	1423	25	699	699
Sheet1

Cell Formulas
Range	Formula
L13:L15	L13	=SUM(M13:O13)
L16:O16	L16	=SUM(L13:L15)

The table from where i need to export is this (Priority 1=High, 2=Medium 3=Low)

Book1
	A	B	C
1	ID Ticket	Creation_time	Priority
2	3450	06.01.2020 05:13	2
3	3451	06.01.2020 09:35	2
4	3452	06.01.2020 09:37	2
5	3454	06.01.2020 11:55	2
6	3456	06.01.2020 16:33	2
7	3457	06.01.2020 17:15	2
8	3458	06.01.2020 17:17	2
9	3459	06.01.2020 17:21	2
10	3461	06.01.2020 19:21	2
11	3462	07.01.2020 00:07	2
12	3463	07.01.2020 01:01	2
13	3464	07.01.2020 01:31	2
14	3468	07.01.2020 07:27	2
15	3470	07.01.2020 08:52	1
16	3471	07.02.2020 09:21	2
17	3472	07.03.2020 11:29	3
18	3473	07.01.2020 12:59	2
19	3476	07.01.2020 15:55	2
20	3477	07.01.2020 15:56	2
21	3478	07.01.2020 15:56	2
22	3479	07.01.2020 18:45	2
23	3480	07.01.2020 20:15	2
24	3481	07.01.2020 20:33	2
25	3483	08.01.2020 08:43	2
26	3484	08.01.2020 09:21	2
27	3486	08.01.2020 11:13	2
28	3489	08.01.2020 19:05	2
29	3490	08.01.2020 19:06	2
30	3491	08.01.2020 19:51	2
31	3492	08.01.2020 21:15	2
32	3493	09.01.2020 07:45	2
33	3494	09.01.2020 09:27	2
34	3495	09.01.2020 12:39	2
35	3496	09.01.2020 12:43	2
36	3497	09.01.2020 17:03	2
37	3499	09.01.2020 17:45	2
38	3500	09.01.2020 18:53	2
39	3501	09.01.2020 19:30	2
40	3503	09.01.2020 21:41	2
41	3504	10.01.2020 07:42	2
42	3505	10.01.2020 08:49	2
43	3506	10.01.2020 08:53	2
44	3507	10.01.2020 09:47	2
45	3508	10.01.2020 10:55	2
46	3509	10.01.2020 11:13	2
47	3514	10.01.2020 13:49	2
48	3515	10.01.2020 13:50	2
49	3518	10.01.2020 20:11	2
50	3519	10.01.2020 20:17	2
51	3520	11.01.2020 11:01	2
52	3521	12.01.2020 23:47	2
Sheet1

How could i fulfill this in the easiest way?

Thanks

Ervin

 

[jasonb75]

From the example it doesn't look like your dates are a valid format, based on that the easiest way that I can think of would be.

Book1
	K	L	M	N	O
12	Volume	2020	January	Feb	Mar
13	High	1	1	0	0
14	Medium	49	48	1	0
15	Low	1	0	0	1
16	Total	51	49	1	1
Sheet12

Cell Formulas
Range	Formula
L13:L15	L13	=SUM(M13:O13)
M13:O15	M13	=COUNTIFS($B:$B,"*."&TEXT(COLUMNS($M13:M13),"00")&"."&$L$12&" *",$C:$C,ROWS(L$13:L13))
L16:O16	L16	=SUM(L13:L15)