Table filter totals - Goal setting

[Sayth]

I think I may be having a bad day but i just can't get the right structure for a solution in my head.

If I have a table that I will be adding activities to.

[TABLE="width: 823"]
<colgroup><col span="7"><col></colgroup><tbody>[TR]
[TD]DATE[/TD]
[TD]Column1[/TD]
[TD]ACTIVITY[/TD]
[TD]DURATION
(minutes)[/TD]
[TD]Practical [/TD]
[TD]Pages[/TD]
[TD]Video[/TD]
[TD]NOTES[/TD]
[/TR]
[TR]
[TD]24/07/2015[/TD]
[TD]6:30 AM[/TD]
[TD]Math CS[/TD]
[TD]60[/TD]
[TD] [/TD]
[TD]33.00[/TD]
[TD] [/TD]
[TD]chapter 1 complete review exercises. [/TD]
[/TR]
[TR]
[TD]24/07/2015[/TD]
[TD]6:50 PM[/TD]
[TD]SuperL[/TD]
[TD]25[/TD]
[TD] [/TD]
[TD]70.00[/TD]
[TD] [/TD]
[TD]reread intro and started next section [/TD]
[/TR]
[TR]
[TD]24/07/2015[/TD]
[TD]19:30[/TD]
[TD]SuperL[/TD]
[TD]15[/TD]
[TD] [/TD]
[TD]24.00[/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]25/07/2015[/TD]
[TD]7:50 AM[/TD]
[TD]HTDP[/TD]
[TD]35[/TD]
[TD] [/TD]
[TD]0.00[/TD]
[TD]0.70[/TD]
[TD]up to booleans[/TD]
[/TR]
</tbody>[/TABLE]

So I want to compare what I have done against my goals (next table) and return a percentage and have this update as I add new activities.
So goals table

[TABLE="width: 328"]
<colgroup><col><col><col><col></colgroup><tbody>[TR]
[TD]Activity[/TD]
[TD]Goal Pages[/TD]
[TD]Goal Video[/TD]
[TD]Goal Practical(mins)[/TD]
[/TR]
[TR]
[TD]Math CS[/TD]
[TD="align: right"]200[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]600[/TD]
[/TR]
[TR]
[TD]SuperL[/TD]
[TD="align: right"]200[/TD]
[TD="align: right"]9[/TD]
[TD="align: right"]600[/TD]
[/TR]
[TR]
[TD]HTDP[/TD]
[TD="align: right"]200[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]600[/TD]
[/TR]
[TR]
[TD]Total[/TD]
[TD="align: right"]600[/TD]
[TD="align: right"]13[/TD]
[TD="align: right"]1800[/TD]
[/TR]
</tbody>[/TABLE]

i was trying to think of the best way to get the totals by creating an actual table, and its here i think I am going wrong.

[TABLE="width: 328"]
<colgroup><col><col><col><col></colgroup><tbody>[TR]
[TD]Activity[/TD]
[TD]Actual Pages[/TD]
[TD]Actual Video[/TD]
[TD]Actual Practival[/TD]
[/TR]
[TR]
[TD]Math CS[/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]SuperL[/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]HTDP[/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Total[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[/TR]
</tbody>[/TABLE]

With a crap formula which totally doesn't work, but i think I am just making it hard in layout to begin with.

=SUMIFS(Sheet1!G11:G15,Sheet1!D11:D15,Sheet1!I9)

 

[Oeldere]

Maybe like this?

row 59 - 63 is a pivot table.

Book1
	A	B	C	D	E	F	G	H
51	DATE	Column1	ACTIVITY	DURATION (minutes)	Practical	Pages	Video	NOTES
52	24-7-2015	6:30 AM	Math CS	60	0	33	0	chapter 1 complete review exercises.
53	24-7-2015	6:50 PM	SuperL	25	0	70	0	reread intro and started next section
54	24-7-2015	19:30	SuperL	15	0	24	0
55	25-7-2015	7:50 AM	HTDP	35	0	0	0,7	up to booleans
56
57
58
59	Rijlabels	Som van Practical	Som van Video	Som van Pages
60	HTDP	0	0,7	0
61	Math CS	0	0	33
62	SuperL	0	0	94
63	Eindtotaal	0	0,7	127
64
65	Activity	Goal Pages	Goal Video	Goal Practical(mins)
66	HTDP	200	4	600
67	Math CS	200	0	600
68	SuperL	200	9	600
69	Total	600	13	1800
70
71	Result (%)
72	HTDP	0,00%	17,50%	0,00%
73	Math CS	0,00%	0,00%	5,50%
74	SuperL	0,00%	0,00%	15,67%
75	Total	0,00%	5,38%	7,06%
Blad1

Cell Formulas
Range	Formula
A72	=A66
A73	=A67
A74	=A68
A75	=A69
B72	=IFERROR(B60/B66,0)
B73	=IFERROR(B61/B67,0)
B74	=IFERROR(B62/B68,0)
B75	=IFERROR(B63/B69,0)
C72	=IFERROR(C60/C66,0)
C73	=IFERROR(C61/C67,0)
C74	=IFERROR(C62/C68,0)
C75	=IFERROR(C63/C69,0)
D72	=IFERROR(D60/D66,0)
D73	=IFERROR(D61/D67,0)
D74	=IFERROR(D62/D68,0)
D75	=IFERROR(D63/D69,0)