Unanswered: Referencing multiple worksheet cells
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?
"For all have sinned, and fallen short of the glory of God"
- God speaking through Paul