When I use Sumif

[Clyde Dickson]

WHEN I USE SUMIF IT APPEARS NOT TO RETURN THE CORRECT VALUE. IS THERE
SOMETHING THAT I AM DOING WRONG This is the formula I am using =SUMIF('[4
Jul 09 Report.xls]1 Jul'!$A$6:$A$980,A3,'[4 Jul 09 Report.xls]1
Jul'!$K$7:$K$980)

Many Thanks,

 

[Eduardo]

Hi,
at the end of your formula you have K7, change it for K6