+ Reply to Thread
Results 1 to 6 of 6

Matching Multiple Critera in SUMIF

  1. 01-30-2014, 01:18 AM #1
    rooboyz is offline
    Registered User
    Join Date
    10-09-2012
    Location
    Australia
    MS-Off Ver
    Excel 2010
    Posts
    41

    Matching Multiple Critera in SUMIF

    Hi Guys,

    I was wondering if you could help me with this one?

    I have attached a sample data piece.

    I'm trying to create an overview which shows a breakdown of the total minutes for each task on each given day.

    I need to get a formula to work in the grey area which sums the total minutes (column C) based on matching two criteras of task (column A) and day (column b).

    Thanks!
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 01-30-2014, 01:22 AM #2
    :) Sixthsense :) is offline
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,788

    Re: Matching Multiple Critera in SUMIF

    In G4 Cell

    =SUMIFS($C$4:$C$22,$A$4:$A$22,$F4,$B$4:$B$22,G$3)

    Drag it down and right...


    If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
    Mark your thread as Solved

    If the suggestion helps you, then Click *below to Add Reputation
    Reply With QuoteRegister To Reply
  3. 01-30-2014, 01:22 AM #3
    vlady is offline
    Forum Moderator vlady's Avatar
    Join Date
    09-22-2011
    Location
    Philippines - OLSHCO -Guimba-Nueva Ecija
    MS-Off Ver
    2021
    Posts
    4,366

    Re: Matching Multiple Critera in SUMIF

    try
    =SUMIFS($C$4:$C$22,$A$4:$A$22,$F4,$B$4:$B$22,G$3)
    use fill handle to drag formula right then down.

    Good day Sixthsense
    I think people forget the word "THANK YOU!!!!" Do you still know it???

    There is a little star ( ADD REPUTATION ) below those person who helped you. Click it to say your "PRIVATE APPRECIATION TO THEIR EFFORT ON THEIR CONTRIBUTIONS "

    Regards,
    Vladimir
    Reply With QuoteRegister To Reply
  4. 01-30-2014, 02:17 AM #4
    :) Sixthsense :) is offline
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,788

    Re: Matching Multiple Critera in SUMIF

    Quote Originally Posted by vlady View Post
    Good day Sixthsense
    Good day to you too
    Reply With QuoteRegister To Reply
  5. 01-30-2014, 02:50 AM #5
    rooboyz is offline
    Registered User
    Join Date
    10-09-2012
    Location
    Australia
    MS-Off Ver
    Excel 2010
    Posts
    41

    Re: Matching Multiple Critera in SUMIF

    Quote Originally Posted by :) Sixthsense :) View Post
    In G4 Cell

    =SUMIFS($C$4:$C$22,$A$4:$A$22,$F4,$B$4:$B$22,G$3)

    Drag it down and right...
    Thank you, you are awesome!

    That worked perfectly.
    Reply With QuoteRegister To Reply
  6. 01-30-2014, 02:51 AM #6
    rooboyz is offline
    Registered User
    Join Date
    10-09-2012
    Location
    Australia
    MS-Off Ver
    Excel 2010
    Posts
    41

    Re: Matching Multiple Critera in SUMIF

    Quote Originally Posted by vlady View Post
    try
    =SUMIFS($C$4:$C$22,$A$4:$A$22,$F4,$B$4:$B$22,G$3)
    use fill handle to drag formula right then down.

    Good day Sixthsense
    Thanks for the quick reply! You are great as well!
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. SUMIF with exclusion critera
    By Zanith in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-13-2013, 04:16 PM
  2. Excel 2007 : Matching critera from two different spreadsheets
    By Donnie in forum Excel General
    Replies: 3
    Last Post: 05-13-2010, 12:00 PM
  3. Pasting multiple sheets in to a workbook based on critera matching file name
    By munkee in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-24-2009, 05:50 PM
  4. sumif: multiple critera including date
    By his5r2m in forum Excel General
    Replies: 3
    Last Post: 05-20-2009, 11:08 AM
  5. [SOLVED] help with sumif formula with multiple critera
    By Matt in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-31-2006, 02:00 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1