I have this as a formula in a cell:
=SUMIF('[2005 Budbook.xls]01XA'!$B$11:$B$17,$K$4:$K$16,'[2005 Budbook.xls]01XA'!$L$11:$L$17)
The criteria I want it to look up is each value in the cells K4:K16. My formula only sums based on the value in K4, it doesn't look in the rest of the range. How would I make this work correctly? Thanks a lot!