Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2003

    Unhappy 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

  2. #2
    Join Date
    Feb 2002
    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.


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts