Results 1 to 2 of 2

Thread: Sumifs for a Number of diferent worksheets
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    Board Regular
    Join Date
    Jan 2009
    Posts
    155
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Sumifs for a Number of diferent worksheets

    Hi,

    I have a total worksheet

    I have 4 worksheets, Week 1, Week 2, Week 3 and Week 4. All set in the same format

    To get the totals I need from each sheet, I have been using Sumifs.

    To add up the totals from the different sheets, is there a alternative to =sumifs(Week1.....)+sumifs(week2...)+,etc.

    Regards

    Matthew

  2. #2
    Board Regular Aryatect's Avatar
    Join Date
    Jun 2019
    Location
    Chicago, USA
    Posts
    308
    Post Thanks / Like
    Mentioned
    3 Post(s)
    Tagged
    1 Thread(s)

    Default Re: Sumifs for a Number of diferent worksheets

    Hi,

    You can try =SUMIF(Week1:Week4!A1:A10........
    Thanks!

    - forum use guidelines, forum rules and terms of use
    - Try searching for your answer first, see how
    - Read the FAQs
    - List of BB codes

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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