How to summarize info with formulas?

[EduPAz]

Hi,

Can someone please help me with this?

I have 5 column of raw data like this: Employee, Month, Day, Type of task, Hours

Without using pivot tables, I would like to summarize the information in a table like this:

	Dec-18	Jan-19	Feb-19	Total quater
	Days	Days	Days
Employee 1
Task a	x	x	x	x
Task b	x	x	x	x

<tbody>
</tbody>

Thanks!

Edu

 

[oldbrewer]

I have 5 column of raw data like this: Employee, Month, Day, Type of task, Hours
Without using pivot tables, I would like to summarize the information in a table like this:
Dec-18	Jan-19	Feb-19	Total quater
Days	Days	Days
Employee 1
Task a	x	x	x	x
Task b	x	x	x	x
				EMPLOYEE	MONTH	DAY	TYPETASK	HOURS
				1	01/01/2018	Mon	a	1500
				HOW DO WE KNOW HOW LONG THE TASK IS - could hours be eg 1500

<colgroup><col span="4"><col><col span="2"><col><col span="3"></colgroup><tbody>
</tbody>

 

[EduPAz]

Sorry, x = number of hours

 

[oldbrewer]

Employee, Month, Day, Type of task, Hours
emp	month	day	tasktype	hours
fred	jan	2	a	8						jan	feb	mar
tom	jan	2	b	7				fred	a	16	0	0
alan	jan	2	a	9				fred	b	17	0	0
fred	jan	3	b	8				tom	a	7	0	0
tom	jan	3	a	7				tom	b	14	0	0
alan	jan	3	b	9				alan	a	18	0	0
fred	jan	4	a	8				alan	b	9	0	0
tom	jan	4	b	7
alan	jan	4	a	9
fred	jan	5	b	9
								fred's 16 for task a derived by
						=SUMPRODUCT(($A$5:$A$14=$I6)*($B$5:$B$14=K$5)*($D$5:$D$14=$J6)*($E$5:$E$14))

<colgroup><col span="18"></colgroup><tbody>
</tbody>