+ Reply to Thread
Page 2 of 2 FirstFirst 1 2
Results 16 to 17 of 17

Applying SUMPRODUCT on few ranges for exact row, need to change for a Range

  1. #16
    Registered User
    Join Date
    06-21-2015
    Location
    fort lauderdale, florida
    MS-Off Ver
    2007
    Posts
    77

    Re: Applying SUMPRODUCT on few ranges for exact row, need to change for a Range

    Hi Mr dave,

    I'm sorry to bother because of my dummy question,
    The question or dilemma : The formula work but i see have a (GD3= (i tough a formula might use a range i.e GD3:GD10)
    I don't think but Is possible to use a range instead of single column?, I didn't mention (because Col B is the same Col GD using Indirect)
    because errors in excel can i use B3:B10 to do the same job??
    How do I use top GD3:GD10 (or B3:B10) or vice versa in the formula ?
    is possible?
    what i need is to pick the 8 top score of either GD or B Col (is the same) count these score in Range EW:FA if belong to "A" (FU Col) then
    display GE3 :GE50 whatever matched and counted column of GD3:GD50 but everything based on top 8 or 10 integer GD3:GD10 (or B3:B10)

    Hope no confuse you..

    thanks !!

  2. #17
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    2007, 365 Insiders
    Posts
    11,306

    Re: Applying SUMPRODUCT on few ranges for exact row, need to change for a Range

    Well, yes I'm confused. In fact I no longer know what the questions are. Let me set with this awhile.
    Dave

+ Reply to Thread
Page 2 of 2 FirstFirst 1 2

Thread Information

Users Browsing this Thread

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

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