+ Reply to Thread
Results 1 to 4 of 4

Sumif for 2 criteria in different columns

  1. #1
    Registered User
    Join Date
    03-30-2006
    Posts
    32

    Sumif for 2 criteria in different columns

    I need to sum the data in column 'C' if it falls within specified date range in column 'A' and is of specified type in Column 'B'. Help!
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor Richard Schollar's Avatar
    Join Date
    05-23-2006
    Location
    Hampshire UK
    MS-Off Ver
    Excel 2002
    Posts
    1,264
    =SUMPRODUCT(--(A4:A11>=D1),--(A4:A11<=D2),--(B4:B11=D3),C4:C11)

    Assumptions:

    D1 contains start date
    D2 contains end date (both dates are inclusive)
    D3 contains type of interest

    Richard
    Richard Schollar
    Microsoft MVP - Excel

  3. #3
    Forum Guru DonkeyOte's Avatar
    Join Date
    10-22-2008
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    21,528
    =SUMPRODUCT(--($A$4:$A$11>=DATE(2009,1,4)),--($A$4:$A$11<=DATE(2009,1,10)),--($B$4:$B$11="one"),$C$4:$C$11)

    the date references etc can of course be references to cells containing the criterion.

    for more info. on Sumproduct see: http://www.xldynamic.com/source/xld.SUMPRODUCT.html

  4. #4
    Forum Moderator Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    27,355
    Hi,

    It's not clear, at least to me, what you mean by 'falling within a specified date date range', what date range?

    Can you give an example of what results you expect - and where and why.

    Rgds

+ 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