Formula works in two, but not third column

[MadCow]

Hello,
I have a formula to sum cells across multiple sheets that workes perfectly for two of the three columns that I need. When I evaluate the formula @ Q1 Summary!E9 the last step of the evaluation is correct, Sumproduct({4,4,4}), but then it produces 0, not 12 as I would expect. I have tried putting the formula in other cells, and tried changing the number format between General and Number to no avail. Now I am completely stuck.

Q1 SUMMARY

	B	C	D	E
8	Site #	FINAL SCORE	FINAL SCORE	FINAL SCORE
9	1000	10

<TBODY>
</TBODY>

Spreadsheet Formulas

Cell Formula C9 =SUMPRODUCT(SUMIF(INDIRECT("'"&Qone&"'!B9:B15"),B9,INDIRECT("'"&Qone&"'!S9:S15"))) D9 =SUMPRODUCT(SUMIF(INDIRECT("'"&Qone&"'!B9:B15"),B9,INDIRECT("'"&Qone&"'!AG9:AG15"))) E9 =SUMPRODUCT(SUMIF(INDIRECT("'"&Qone&"'!B9:B15"),B9,INDIRECT("'"&Qone&"'!AU9:AU15"))) <TBODY> </TBODY>

Names in Formulas Cell Name Applies to C9 Qone ='Q1 SUMMARY'!$K$1:$K$3 D9 Qone ='Q1 SUMMARY'!$K$1:$K$3 E9 Qone ='Q1 SUMMARY'!$K$1:$K$3 <TBODY> </TBODY> <TBODY> </TBODY>

<TBODY>
</TBODY>

P1 2013

	B	S	AG	AU
8	Site #	RANK	RANK	RANK
9	1000	6		4

<TBODY>
</TBODY>

Spreadsheet Formulas

Cell Formula S9 =RANK(R9,$R$9:$R$15,0) AU9 =RANK(AT9,$AT$9:$AT$15,0) <TBODY> </TBODY>

<TBODY>
</TBODY>

P2 2013

	B	S	AG	AU
8	Site #	RANK	RANK	RANK
9	1000	4		4

<TBODY>
</TBODY>

Spreadsheet Formulas

Cell Formula S9 =RANK(R9,$R$9:$R$15,0) AU9 =RANK(AT9,$AT$9:$AT$15,0) <TBODY> </TBODY>

<TBODY>
</TBODY>

P3 2013

	B	S	AG	AU
8	Site #	RANK	RANK	RANK
9	1000

<TBODY>
</TBODY>

Spreadsheet Formulas

Cell Formula S9 =IFERROR(RANK(R9,$R$9:$R$15,0),0) AU9 =IFERROR(RANK(AT9,$AT$9:$AT$15,0),0) <TBODY> </TBODY>

<TBODY>
</TBODY>

Excel tables to the web >> Excel Jeanie HTML 4