Results 1 to 7 of 7

SUMIF across multiple columns and rows

Threaded View

  1. #1
    Registered User
    Join Date
    10-01-2012
    Location
    Prince George
    MS-Off Ver
    Excel 2010
    Posts
    6

    SUMIF across multiple columns and rows

    I have a data set that shows dates across the columns and PO #s down rows. The same PO number can be used several times down the row as several items can be on the same PO.

    What I would like to do is add all values from a PO across a date range. This should be in a formula, not a pivot table.

    Attached Image of data set

    Dataset.JPG

    Attached example spreadsheet

    I can solve this by stringing together several IF(SUMIF()) formulas as indicated however with a large amount of rows and columns, this is not practical. A dummy row or column to subtotal the various PO's is not practical either.

    I am looking for something more eloquent.

    In my example I want to add all PO values for PO 10 from Jan 2 to Jan 4th.

    My actual spreadsheet will have multiple POs being added over multiple date ranges (date ranges can be different for each PO)
    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. Sumif or Sumproduct with Multiple Rows & Columns
    By vulches in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 05-12-2017, 02:06 AM
  2. SUMIF Rows and Columns Not working
    By SHUTTEHFACE in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 09-29-2014, 05:59 AM
  3. Replies: 9
    Last Post: 12-15-2013, 10:05 PM
  4. Unable to SUMIF across columns and rows
    By sandy.rogers in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 07-21-2012, 09:11 AM
  5. [SOLVED] SUMIF with rows and columns
    By David Howdon in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 10-17-2005, 01:05 PM

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