Calculating Totals from Equations in different Footers

[mearmortal]

I have one field footer with the following calculation in it.
=(Sum([DefectQuantity])/((-1*Sum([Key]=1))*[OFDNumber]))*1000000

The result of which is a number.
this calculation may be repeated 6 times in the footer for different [Stations]
As a [Part] has multiple [Stations] the Part Footer needs to have a calculation that adds up the results of each of the individual [stations]. Unfortunatly the [OFDNumber] field changes values depending on which [Station] is being calculated.

Can anyone help me with this one
I've tried running sum on the text box name but that still does not work.

 

[GoDawgs]

So you just want to get a sum of the 6 numbers that are showing up in the text boxes? Seems like a =Sum([textbox]) should work in this case...

 

[mearmortal]

That's what I thought. But on preview I have to enter a parameter value for [Text40].

Is it because in one footer I have: -
[text40] with =(Sum([DefectQuantity])/((-1*Sum([Key]=1))*[OFDNumber]))*1000000 type, general number
and
[Text57] with =([text40]/[text49]) type, percentage
and in the next footer I have: -

[Text49] with =Sum([Text40]) type, General Number

Any more ideas please