+ Reply to Thread
Results 1 to 3 of 3

Sumif on multiple matching rows

  1. #1
    Registered User
    Join Date
    05-07-2012
    Location
    Australia
    MS-Off Ver
    Excel 2007
    Posts
    2

    Sumif on multiple matching rows

    Hi,

    I am trying to find a function to sum all the hours I have completed by project to see how much time in total has been spent on each project from a worksheet that resembles the below. Do you know what function could sum the totals 29, 45 & 46?


    Project Mon Tue We Thu Fri
    12345 8 4 2 1
    10001 4
    21211 6 7 8

    12345 1 1 1 5
    10001 7
    21211 7 7 3 8

    12345 6
    10001 8 2 8 8 8
    21211



    Total 12345 = 29
    Total 10001 = 45
    Total 21211 = 46

    TimeSheets_test.xlsx

  2. #2
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    24,604

    Re: Sumif on multiple matching rows

    Put this array* formula in M2:

    =SUM(IF($A$2:$A$37=L2,$C$2:$I$37))

    then copy down.

    *An array formula must be committed using the key combination of Ctrl-Shift-Enter rather than the usual <Enter>

    Hope this helps.

    Pete

  3. #3
    Registered User
    Join Date
    05-07-2012
    Location
    Australia
    MS-Off Ver
    Excel 2007
    Posts
    2

    Re: Sumif on multiple matching rows

    Legend Pete! Thanks.

    It was the Ctrl-Shift-Enter that got me. I thought I was going nuts.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1