Howdy,

I've looked all over the 'net but I can't find a solution for this.

I am trying to reference multiple cells across multiple worksheets e.g. Sheet1heet3!B4 - in other words, all B4 cells in sheets 1, 2 and 3. However, I keep hitting a brick wall (errrors).

I'm trying to use this reference/syntax in a SUMIF formula (in the range and sum_range of course). Anyone know how to overcome this problem?

I think the only way you could do this is to have two extra cells on the first sheet which reference each of the cells on the other two sheets and then run a sumif on them.

Dave.