Help me please "sumif"

[jcamota]

Good morning,

I have an excel book where records of the hours of entry and exit of students (Test novo_Agosto_2011.xls). This book is divided into 31 pages that match the day of the month. These sheets are linked to another book where I keep the data from student and now intend to also keep the accumulated hours of each (Listautentes.xls). Everything is working with the PROCV function.

My problem that I can not overcome the accumulated hours with the SUMIF function not working. I can not get more than this number of parameters and tell me that is too large:
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o> </o>
=SOMA.SE('[Teste novo_Agosto_2011.xls]Dia 01'!$A$6:$A$75;A2;'[Teste novo_Agosto_2011.xls]Dia 01'!$J$6:$J$75)+SOMA.SE('[Teste novo_Agosto_2011.xls]Dia 02'!$A$6:$A$75;A2;'[Teste novo_Agosto_2011.xls]Dia 02'!$J$6:$J$75)+SOMA.SE('[Teste novo_Agosto_2011.xls]Dia 03'!$A$6:$A$75;A2;'[Teste novo_Agosto_2011.xls]Dia 03'!$J$6:$J$75)+SOMA.SE('[Teste novo_Agosto_2011.xls]Dia 04'!$A$6:$A$75;A2;'[Teste novo_Agosto_2011.xls]Dia 04'!$J$6:$J$75)+SOMA.SE('[Teste novo_Agosto_2011.xls]Dia 05'!$A$6:$A$75;A2;'[Teste novo_Agosto_2011.xls]Dia 05'!$J$6:$J$75)+SOMA.SE('[Teste novo_Agosto_2011.xls]Dia 06'!$A$6:$A$75;A2;'[Teste novo_Agosto_2011.xls]Dia 06'!$J$6:$J$75)+SOMA.SE('[Teste novo_Agosto_2011.xls]Dia 07'!$A$6:$A$75;A2;'[Teste novo_Agosto_2011.xls]Dia 07'!$J$6:$J$75)+SOMA.SE('[Teste novo_Agosto_2011.xls]Dia 08'!$A$6:$A$75;A2;'[Teste novo_Agosto_2011.xls]Dia 08'!$J$6:$J$75)

I tried putting the following formula, but is not ok:
<o> </o>
=SOMA.SE('[Teste novo_Agosto_2011.xls]Dia 08:Dia 10'!$A$6:$A$75;A3;'[Teste novo_Agosto_2011.xls]Dia 08:Dia 10'!$A$6:$A$75)
<o> </o>
<o>I Put the books on the following link:</o>

http://www.sendspace.com/filegroup/0...leMBgvgAdLHBgA<o></o>
<o> </o>
<o>Someone help me please?</o>
<o></o>
<o>Thanks</o>
<o></o>
<o>João</o>
<o></o>