Results 1 to 2 of 2

Thread: summing workhours of weeks
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    New Member
    Join Date
    Jan 2018
    Posts
    13
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default summing workhours of weeks

    How to count together all numbers from rows under column b that have same number in column a? (like 20 would be 1+4+2= and 25 3+6+7= ) List is long and would be nice to do this automatically.


    a=week nr , b=work hours


    a,b
    --
    20,1
    20,4
    20,2
    23,3
    24,3
    25,3
    25,6
    25,7


    thankyou!

  2. #2
    MrExcel MVP FormR's Avatar
    Join Date
    Aug 2011
    Location
    UK
    Posts
    6,092
    Post Thanks / Like
    Mentioned
    24 Post(s)
    Tagged
    2 Thread(s)

    Default Re: summing workhours of weeks

    Hi, sounds like you want SUMIFS() - for example:

    Excel 2013/2016
    ABCDE
    1WEEK NRHOURSWEEK NRTOTAL HOURS
    2201207
    3204233
    4202243
    52332516
    6243
    7253
    8256
    9257

    Sheet1



    Worksheet Formulas
    CellFormula
    E2=SUMIFS(B:B,A:A,D2)

    [code]your code[/code]

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
  •