Results 1 to 2 of 2

Thread: Excel (2002)

  1. #1
    New Lounger
    Join Date
    Jan 2001
    Location
    New York
    Posts
    7
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Excel (2002)

    Is it possible to use the sumif function across several worksheets within a single Excel file? For example, can the formula =sumif("W1"!$1:$1,$A3,"W1"!$3,$3), which returns the sum of values in row 3 on worksheet W1 in columns for which the row 1 value equals the value in cell A3, be extended to cover worksheets W2 and W3 as well? If so, how would this be done? Thanks!

  2. #2
    Super Moderator
    Join Date
    May 2002
    Location
    Canberra, Australian Capital Territory, Australia
    Posts
    5,054
    Thanks
    2
    Thanked 417 Times in 346 Posts

    Re: Excel (2002)

    Hi,

    The easiest way would to be to use multiple sumifs in the one formula, eg:
    ==SUMIF('W1'!$1:$1,$A3,'W1'!$3:$3)+SUMIF('W2'!$1:$ 1,$A3,'W2'!$3:$3)+SUMIF('W3'!$1:$1,$A3,'W3'!$3:$3)

    Cheers
    Cheers,

    Paul Edstein
    [MS MVP - Word]

Posting Permissions

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