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

"Clyde Dickson" wrote:

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,