Obtain a summary table of work incident reports

[zelarra]

Hi guys.

I'll tell you.

I have a spreadsheet where I write down the work incident reports.

My goal is to get a table where the incident reports and justifications appear by year.

When I submit an incident report, I can do it for individual days; or for full days and indicate the ones I'm going to take.

With the justifications , there are incident reports that don't require submitting a justifications , such as vacations, but for medical appointments, for example, it does.

So, I'll show you a screenshot of the table, and what I want to get.

If I need to share a spreadsheet, tell me how to do it.

Thank you very much.

 

[awoohaw]

Try this:

Book1
	A	B	C	D	E	F	G	H	I
1	Date	Incidencia	Codigo	Inicio	Final	Duracion	Incident Report	Days	Justification
2	2023-04-20						Yes. Ungrouped		Yes
3	2023-04-28						Yes. Ungrouped		Yes
4	2023-05-04						Yes. Ungrouped		Yes
5	2023-05-11						Yes. Ungrouped		Yes
6	2023-05-19						Yes. Grouped	2	No
7	2023-05-22						Yes. Grouped	2	No
8	2023-05-25						Yes. Ungrouped		Yes
9	2023-06-13						No		No
10	2023-07-17						Yes. Ungrouped		Yes
11	2023-07-18						Yes. Ungrouped		Yes
12	2023-07-19						Yes. Ungrouped		Yes
13	2023-07-28						Yes. Grouped	2	No
14	2023-08-01						Yes. Grouped	2	No
15	2023-08-09						Yes. Ungrouped		Yes
16	2023-08-10						Yes. Ungrouped		Yes
17	2023-08-22						Yes. Grouped		No
18	2023-08-23						Yes. Grouped	10	No
19	2023-08-24						Yes. Grouped	10	No
20	2023-08-25						Yes. Grouped	10	No
21	2023-08-28						Yes. Grouped	10	No
22
23
24	2023	20	10
Sheet1

Cell Formulas
Range	Formula
B24	B24	=SUM(--(YEAR(A2:A21)=A24))
C24	C24	=SUM((--(YEAR(A2:A21)=A24))*($I$2:$I$21="Yes"))

 

[zelarra]

Thanks, @awoohaw , but i don't get the results I want.

Here you have an example with the table and the results I want to get:

Dropbox

www.dropbox.com