number error

[arnab0711]

Hi,
Can you tell me,why the numbers are not flowing in c4:h22 of final sheet.

[Bob Phillips]

You are looking at values in A1:A8 on Final, but you have cleared them.

[arnab0711]

Hi xld,
They are not cleared,I have changed the font color to white.

[Bob Phillips]

Hi xld,
They are not cleared,I have changed the font color to white.

Alright, smarty-pants :)

You have been playing about with the dates but not properly following through

=IF(ISNUMBER($B4),
IF(INDEX(Graph!$E$7:$E$28,Final!$B4),
SUMPRODUCT(SUMIFS(INDIRECT($C4&"!"&D$1),INDIRECT($C4&"!"&$C$1),INDEX($A$1:$A$8,$E$2),INDIRECT($C4&"!"&$C$2),INDEX(months,Final!$F$2))),
NA()),NA())

You should employ me as a consultant on this :devil2: :devil2:

[arnab0711]

You bet :)
This thing is driving me nuts,I am totally drained..