Results 1 to 9 of 9

Is a multiple SUMIF formula possible in Excel 2003?

Threaded View

  1. #1
    Registered User
    Join Date
    12-02-2012
    Location
    Auckland, New Zealand
    MS-Off Ver
    Excel 2003
    Posts
    40

    Is a multiple SUMIF formula possible in Excel 2003?

    After searching the forum it seems that what I need is SUMIFS, but that's not available in my rather dated version of Excel.

    I need a SUMIF formula that will return a total from Col.I only if specified conditions are met in both Col.J and Col.K.

    I've attempted to attach a copy of the worksheet, which is a list of wiring required to make up a harness (loom) for a car. Cell W21 contains a single SUMIF formula, but it needs to be combined with the formula in X21, in other words both cable size (Col.J) and colour (Col.K) coincide.

    Any help with this will be greatly appreciated.

    Richard
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] SUMIF Formula for Excel 2003
    By forexcellence13 in forum Excel General
    Replies: 13
    Last Post: 02-10-2013, 03:59 AM
  2. Multiple formula for accounting excel 2003
    By wakeup75 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 11-19-2012, 04:07 PM
  3. Replies: 2
    Last Post: 04-24-2012, 10:36 AM
  4. SUMIF Multiple arrays in 2003
    By snoproladd in forum Excel General
    Replies: 0
    Last Post: 02-20-2012, 03:50 PM
  5. SUMIF multiple criteria (Excel 2003 - Windows XP)
    By barongreenback in forum Excel General
    Replies: 4
    Last Post: 03-13-2010, 06:19 AM
  6. SUMIF Multiple Criteria - Excel 2003
    By VegasL in forum Excel General
    Replies: 10
    Last Post: 01-11-2010, 08:30 AM
  7. SUMIF with multiple criteria in Excel 2003
    By stoneglobe in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 03-05-2009, 08:33 AM
  8. [SOLVED] How do I use wildcard characters in Excel 2003 sumif formula?
    By Erik T in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-13-2006, 04:45 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