Sum if function

Thanks Thanks:  0
Likes Likes:  0
Results 1 to 2 of 2

Thread: Sum if function

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

    Default Sum if function

     
    I have a file that contains hours by department by job code down to the earnings code level. What I am trying to do is sum up in separate columns: worked hours, paid hours and Overtime hours.
    I have a separate table that tells me which earnings codes counts towards Worked/Paid/OT.
    So if I am trying to sum worked hours I need to go to the earnings code file column D, if that is “True” go over to the respective row take that number and find it on the main sheet column F and sum column I

    This is what i have:
    =SUMIFS(I:I,'[Earnings Codes.xlsx]Sheet1'!$D:$D,"TRUE",F:F,'[Earnings Codes.xlsx]Sheet1'!$B:$B)
    but the number I am getting, is no where near close to what it should be.
    Excel 2007 & 2010

  2. #2
    Board Regular
    Join Date
    Sep 2009
    Location
    Chennai
    Posts
    246
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Sum if function

      
    Hi,

    Can you please refer the below links.

    Excel SUMIFS Sum With Multiple Criteria | Contextures Blog
    SUMIFS function - Excel - Office.com

    The problem with second criteria please correct the formula either by F:F or $B:$B.

    Thanks,
    SK

User Tag List

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
  •  

 

 
DMCA.com