Need Help with DSUM function

[Krbass01]

I have a workbook we use for auditing/proposing projects that was created in Excel 2003 and when I opened and converted it to 2010 my DSUM functions are working properly. I am not the person who built it originally and I am not by any means an Excel expert so I am a little lost and need some help. I have upgraded to 2010 and need to get it to work properly in 2010.

My first question - Is there something I can do when coverting the 2003 version to 2010 to maintain the functions...did I possibly do something that would screw up the integrity of the formulas? When I open the 2003 in 2010 I get the following error "This workbook has lost its VBA project, ActiveX controls and any other programmability-related features".

Secondly - Here's the data from the first workbook:

Audit Sheet:
[TABLE="width: 979"]
<tbody>[TR]
[TD][/TD]
[TD]Floor[/TD]
[TD]Room Description[/TD]
[TD]Fixt #[/TD]
[TD]Qty[/TD]
[TD]INOPS[/TD]
[TD]Total[/TD]
[TD]Comp[/TD]
[TD]Incomp[/TD]
[/TR]
[TR]
[TD="align: right"][/TD]
[TD]3rd[/TD]
[TD]Reception[/TD]
[TD]3[/TD]
[TD="align: right"]2[/TD]
[TD] [/TD]
[TD="align: right"]2[/TD]
[TD] [/TD]
[TD="align: right"]2[/TD]
[/TR]
[TR]
[TD="align: right"][/TD]
[TD]3rd[/TD]
[TD]Reception[/TD]
[TD]5[/TD]
[TD="align: right"]2[/TD]
[TD] [/TD]
[TD="align: right"]2[/TD]
[TD] [/TD]
[TD="align: right"]2[/TD]
[/TR]
[TR]
[TD="align: right"][/TD]
[TD]3rd[/TD]
[TD]Reception[/TD]
[TD]28[/TD]
[TD="align: right"]2[/TD]
[TD] [/TD]
[TD="align: right"]2[/TD]
[TD] [/TD]
[TD="align: right"]2[/TD]
[/TR]
[TR]
[TD="align: right"][/TD]
[TD]3rd[/TD]
[TD]Open Cubicle Area[/TD]
[TD]3[/TD]
[TD="align: right"]24[/TD]
[TD] [/TD]
[TD="align: right"]24[/TD]
[TD] [/TD]
[TD="align: right"]24[/TD]
[/TR]
[TR]
[TD="align: right"][/TD]
[TD]3rd[/TD]
[TD]Open Cubicle Area[/TD]
[TD]8[/TD]
[TD="align: right"]2[/TD]
[TD] [/TD]
[TD="align: right"]2[/TD]
[TD] [/TD]
[TD="align: right"]2[/TD]
[/TR]
[TR]
[TD="align: right"][/TD]
[TD]3rd[/TD]
[TD]Office #1[/TD]
[TD]3[/TD]
[TD="align: right"]1[/TD]
[TD] [/TD]
[TD="align: right"]1[/TD]
[TD] [/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD="align: right"][/TD]
[TD]3rd[/TD]
[TD]Office #2[/TD]
[TD]2[/TD]
[TD="align: right"]4[/TD]
[TD] [/TD]
[TD="align: right"]4[/TD]
[TD] [/TD]
[TD="align: right"]4[/TD]
[/TR]
[TR]
[TD="align: right"][/TD]
[TD]3rd[/TD]
[TD]Open Cubicle Area[/TD]
[TD]3[/TD]
[TD="align: right"]24[/TD]
[TD] [/TD]
[TD="align: right"]24[/TD]
[TD] [/TD]
[TD="align: right"]24[/TD]
[/TR]
[TR]
[TD="align: right"][/TD]
[TD]3rd[/TD]
[TD]Open Cubicle Area[/TD]
[TD]8[/TD]
[TD="align: right"]2[/TD]
[TD] [/TD]
[TD="align: right"]2[/TD]
[TD] [/TD]
[TD="align: right"]2[/TD]
[/TR]
</tbody><colgroup><col><col><col><col><col><col><col><col><col></colgroup>[/TABLE]



Here's the 2nd worksheet with DSUM Function - This is supposed to find all Fixt # that match and total them. Here;s the formula being used and then a copy of the data in the 2nd worksheet

Current Formula - =DSUM('Input Form'!$A$5:$L$681,4+1,$A7:$A8)

2nd worksheet Data:

[TABLE="width: 299"]
<tbody>[TR]
[TD]Fixt #[/TD]
[TD]Qty[/TD]
[TD]Adj[/TD]
[TD]Total[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD="align: right"]10[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]10[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD="align: right"]26[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]26[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD="align: right"]225[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]225[/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD="align: right"]8[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]8[/TD]
[/TR]
[TR]
[TD]8[/TD]
[TD="align: right"]18[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]18[/TD]
[/TR]
[TR]
[TD]16[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]2[/TD]
[/TR]
[TR]
[TD]17[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]4[/TD]
[/TR]
[TR]
[TD]20[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]21[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]28[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]2[/TD]
[/TR]
</tbody><colgroup><col><col><col><col></colgroup>[/TABLE]



Here's the 2nd page of the 2010 workbook after converting:

DSUM formula: =DSUM('Input Form'!$A$5:$M$681,7+1,$A37:$A38)

Here's how the data is being returned:
[TABLE="width: 451"]
<tbody>[TR]
[TD]Fixt #[/TD]
[TD]Qty[/TD]
[TD]Adj[/TD]
[TD]Total[/TD]
[TD]Comp[/TD]
[TD]Incomp[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD] [/TD]
[TD="align: right"]10[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD="align: right"]133[/TD]
[TD="align: right"]10[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD="align: right"]133[/TD]
[TD="align: right"]10[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD="align: right"]133[/TD]
[TD="align: right"]10[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD="align: right"]133[/TD]
[TD="align: right"]10[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD]6[/TD]
[TD="align: right"]133[/TD]
[TD="align: right"]10[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD]7[/TD]
[TD="align: right"]133[/TD]
[TD="align: right"]10[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD]8[/TD]
[TD="align: right"]133[/TD]
[TD="align: right"]10[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD]9[/TD]
[TD="align: right"]133[/TD]
[TD="align: right"]10[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[/TR]
</tbody><colgroup><col><col><col><col><col><col></colgroup>[/TABLE]

Any help is appreciated!! Or is anyone interested in helping me build a new one from scratch for $$?