+ Reply to Thread
Results 1 to 3 of 3

SUMIFS on multiple columns and multiple criteria

  1. #1
    Registered User
    Join Date
    01-10-2018
    Location
    Scotland
    MS-Off Ver
    Office 2013
    Posts
    16

    SUMIFS on multiple columns and multiple criteria

    Hi

    I have a problem creating a formula to do what I want it to do. I have tried anumber of options but I just can't seem to get it to work.

    Basically, it is a spreadsheet torecord late coming and I wish to add up all the time lost due to different reasons for each person (columns F:I). The original spreadsheet contains instances of up to 43 lates so is quite large.

    Is this even possible? Any help on this would be greatly appreciated.
    Attached Files Attached Files

  2. #2
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... based in Ireland... but I could be anywhere in the world
    MS-Off Ver
    Office 365 for PC.
    Posts
    34,981

    Re: SUMIFS on multiple columns and multiple criteria

    Change F3 to I3 to match your critieria and then use ths in F4, copied across and down:

    =IFERROR(1/(1/SUMIF($M4:$U4,F$3,$L4:$T4)),"")
    Attached Files Attached Files
    Glenn



  3. #3
    Registered User
    Join Date
    01-10-2018
    Location
    Scotland
    MS-Off Ver
    Office 2013
    Posts
    16

    Re: SUMIFS on multiple columns and multiple criteria

    Thank you so much Glenn. I would never have got this in a month of Sundays. Really appreciate your help!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 4
    Last Post: 06-14-2017, 01:51 AM
  2. Replies: 3
    Last Post: 12-09-2015, 03:10 AM
  3. SUMIFS or SUMPRODUCT with Multiple Columns and with Date Criteria
    By eac8423 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 04-04-2014, 05:20 PM
  4. Multiple Criteria Sumifs in Multiple Columns
    By arowberry in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-04-2014, 06:06 PM
  5. Need help understanding sumifs columns with multiple criteria
    By igoodable in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-28-2014, 02:27 PM
  6. Sumifs with multiple criteria in multiple columns
    By Ganesh7299 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 10-30-2013, 01:30 AM
  7. [SOLVED] SUMIF or SUMIFS adding time where criteria is in multiple columns
    By 66ev in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 08-14-2013, 02:21 PM

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