Results 1 to 4 of 4

Maximum & Minimum Dates based on Condition

Threaded View

  1. #1
    Registered User
    Join Date
    03-06-2008
    Posts
    10

    Maximum & Minimum Dates based on Condition

    Hi,

    I'm trying to get the maximum and minimum dates in a range based on an Identity, and then sum a quantity (of widgets) based on the dates in that range.

    I can do this individually, but want to be able to sum on the whole range...

    In the atached spreadsheet, for Identity 1, the total widgets is 420, completed in 488 days.

    For identity 2, the total widgets is 1242, completed in 488 days.

    My problem is working out the number of days in the range based on the Identity number.

    I'm having difficulty determining how to get the max date based on Identity 1... i've tried SUMPRODUCT(MAX(Date Range))*(Identity Range = 1))

    I also need to get the minimum date for the same identity, which I assume will similar.

    I'd appreciate any pointers. Tks.
    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] Using Today() and making it Static based on a particular condition.
    By all4excel in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 05-29-2008, 05:09 PM
  2. insert new row based on dates
    By inkexit in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-16-2008, 12:34 PM
  3. Creating two different charts based on a single pivot table based on condition
    By exlnovice in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-26-2008, 06:21 AM
  4. Ending a formula, based on condition...
    By razorangel in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 12-11-2007, 02:47 PM
  5. Getting Minimum and maximum level from a cell
    By a94andwi in forum Excel General
    Replies: 9
    Last Post: 03-20-2007, 09:01 AM

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