Nested IF isnt working right..Why?

C

Curtis

=IF($C$5=1,-SUMPRODUCT(('[YTDTB ACTUAL
''09-10.xls]YTDTB99'!$A$3:$A$277=$B69)*('[YTDTB ACTUAL
''09-10.xls]YTDTB99'!$D$1:$CI$1=E$7)*('[YTDTB ACTUAL
''09-10.xls]YTDTB99'!$D$3:$CI$277)),0),IF($C$5=2,-SUMPRODUCT(('[YTDTB ACTUAL
''09-10.xls]YTDTB00'!$A$3:$A$277=$B69)*('[YTDTB ACTUAL
''09-10.xls]YTDTB00'!$D$1:$CI$1=E$7)*('[YTDTB ACTUAL
''09-10.xls]YTDTB00'!$D$3:$CI$277)),0)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sumproduct not working 3
Sumproduct not working 3
Double Lookup 5
Calculating an average of data between two dates 1
How to Shorten a repetitive formula to include more references. 7
Will not give accurate totals. 3
Formula until condition met 4
IF ARRAY with multiple conditions. 1

Top