Ok, here's my problem. I would like an eash way of copying the sum formula across row B, each one with sheet number references corresponding to row A. ie. B1 is suming Sheet1, B2 is summing Sheet2, B3 is suming Sheet3. I tried something like =sum(Sheet&A1) and copy across row B but that doesn't work. Any ideas? Thanks.