Results 1 to 23 of 23

Min with sumproduct

Threaded View

JJGF Min with sumproduct 03-08-2015, 03:14 PM
jeffreybrown Re: Min with sumproduct 03-08-2015, 03:24 PM
JJGF Re: Min with sumproduct 03-08-2015, 03:29 PM
FDibbins Re: Min with sumproduct 03-08-2015, 03:53 PM
jeffreybrown Re: Min with sumproduct 03-08-2015, 03:36 PM
JJGF Re: Min with sumproduct 03-08-2015, 03:37 PM
jeffreybrown Re: Min with sumproduct 03-08-2015, 03:41 PM
TMS Re: Min with sumproduct 03-08-2015, 03:55 PM
JJGF Re: Min with sumproduct 03-08-2015, 04:04 PM
JJGF Re: Min with sumproduct 03-08-2015, 04:17 PM
FDibbins Re: Min with sumproduct 03-08-2015, 04:26 PM
JJGF Re: Min with sumproduct 03-08-2015, 04:28 PM
JJGF Re: Min with sumproduct 03-08-2015, 04:41 PM
daddylonglegs Re: Min with sumproduct 03-09-2015, 06:47 PM
FDibbins Re: Min with sumproduct 03-08-2015, 04:58 PM
JJGF Re: Min with sumproduct 03-08-2015, 05:09 PM
TMS Re: Min with sumproduct 03-08-2015, 05:16 PM
JJGF Re: Min with sumproduct 03-08-2015, 05:24 PM
FDibbins Re: Min with sumproduct 03-08-2015, 05:19 PM
TMS Re: Min with sumproduct 03-08-2015, 05:31 PM
FDibbins Re: Min with sumproduct 03-08-2015, 05:40 PM
JJGF Re: Min with sumproduct 03-08-2015, 05:46 PM
FDibbins Re: Min with sumproduct 03-08-2015, 05:54 PM
  1. #1
    Forum Contributor
    Join Date
    12-06-2012
    Location
    sacramento,calif
    MS-Off Ver
    Excel 2010
    Posts
    217

    Min with sumproduct

    Hi, I need a formula that finds the minimum from one col if criteria is met in another col, example:

    A1:A4: 3,2,4,1
    B1:B4: B,C,A,D

    If the criteria I need is "D" and the minimum for the whole set of A1:A4 (which is 1 above) corresponds, then true.

    I don't need the min only for the group D, example:

    A1:A4: 1,2,4,5
    B1:B4: B,D,A,D

    Here the min for "D" is 2 but it is not the min for the whole set, I don't want that. I want only if "D" is matched with "1".
    Thanks.
    Last edited by JJGF; 03-08-2015 at 03:49 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Count SUMPRODUCT Members / Average of SUMPRODUCT
    By Shingaru in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 04-10-2014, 03:59 PM
  2. Replies: 1
    Last Post: 05-19-2012, 02:54 AM
  3. Replies: 5
    Last Post: 04-20-2012, 08:54 AM
  4. Replies: 6
    Last Post: 03-09-2011, 08:01 AM
  5. Using a SumProduct Count to find a SumProduct Total?
    By XL021710 in forum Excel General
    Replies: 3
    Last Post: 02-18-2010, 08:31 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