An array formula reads as follows:

=AG2 / (((P2 / ('[Team Data.xls]Data'$I / 5)) * '[Team Data.xls]Data'$J) - Q2)

The problem is that the formula is missing the following:
[TeamData]Data!$I is only valid, if E2 in the current file equals a value in
$B in the TeamData file AND and if G2 equals a value in $C.

I need to know how to modify the formula above to include these additional
components. Thank you.

Bob