+ Reply to Thread
Results 1 to 4 of 4

Multiple criteria SUMPRODUCT (3 criteria) Excel 2003

  1. #1
    Registered User
    Join Date
    01-03-2013
    Location
    Bracknell, England
    MS-Off Ver
    Excel 2013, Excel 2003
    Posts
    8

    Multiple criteria SUMPRODUCT (3 criteria) Excel 2003

    Hello all

    I attach a workbook. One sheet has my invitees in it (CURRENT RECORDS), the sheet called CEREMONIES contains SUMPRODUCT formulae to show how many adults and how many children have been invited to a ceremony. I have used SUMPRODUCT to calculate these. If I want to show how many have accepted and how many children are attending I can use SUMIFS and it works. My problem is that at work I have to use Excel 2003 (aaargh) which does not include SUMIFS.

    I could use pivot tables in Excel 2003 but have a feeling that my colleagues wont like them at all.

    Can anyone help me with the 3+ criteria? I tried some code from another site but it didn't work.

    Many thanks
    Attached Files Attached Files
    Last edited by lelrich; 11-10-2014 at 05:49 AM. Reason: solved

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: Multiple criteria SUMPRODUCT (3 criteria) Excel 2003

    Hi

    Not exactly sure where you needed to put this, but I added to the formula in B5. The same method would apply to any others you want to add to...
    =SUMPRODUCT((Current_records!L$2:$L$202=$A$2)*(Current_records!$M$2:$M$202=$B$2)*(Current_records!$N$2:$N$202=Ceremonies!$C$2)*(Current_records!$H$2:$H$202))
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  3. #3
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: Multiple criteria SUMPRODUCT (3 criteria) Excel 2003

    Happy to help, thanks for the feedback

  4. #4
    Registered User
    Join Date
    01-03-2013
    Location
    Bracknell, England
    MS-Off Ver
    Excel 2013, Excel 2003
    Posts
    8

    Re: Multiple criteria SUMPRODUCT (3 criteria) Excel 2003

    My pleasure

+ 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: 6
    Last Post: 08-04-2013, 11:53 AM
  2. Add cells with multiple criteria in Excel 2003
    By ynot2010 in forum Excel General
    Replies: 4
    Last Post: 03-04-2010, 05:43 AM
  3. Excel 2003: COUNTIF/SUMPRODUCT, Multiple Criteria w/Wildcard
    By EricF in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-24-2008, 09:41 PM
  4. [SOLVED] Excel 2003 multiple criteria
    By anike007 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-10-2006, 03:45 PM
  5. [SOLVED] Select by multiple criteria (Excel 2003)
    By Biff in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-06-2005, 04:05 AM

Tags for this Thread

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