+ Reply to Thread
Results 1 to 3 of 3

Sum product, logical help

Hybrid View

  1. #1
    Forum Contributor
    Join Date
    11-26-2010
    Location
    usa
    MS-Off Ver
    Office 365
    Posts
    1,233

    Sum product, logical help

    Hello all

    Just one quick inquiry as I'm struggling with a simple issue.

    I have three sum products on my workbook

    1) searches for sales ppl whose revenue change (by country, column i,) was > +10%
    =SUMPRODUCT(--('Contest Effectiveness 2011'!$I$10:$I$137='Summary 2011'!J$16)*--('Contest Effectiveness 2011'!$P$10:$P$137>K12))

    where K12 = +10%
    column P = % breakdown

    2) searches for sales ppl whose revenue change (by country, column i,) was < -10%
    =SUMPRODUCT(--('Contest Effectiveness 2011'!$I$10:$I$137='Summary 2011'!J$16)*--('Contest Effectiveness 2011'!$P$10:$P$137>M12))

    where M12 = < -10%
    where P = % breakdown


    The final and third that im struggling to define is the in between (+0 and +9.99%)???

    can someple help me define this one, pls and much appreciated!

  2. #2
    Valued Forum Contributor Sadath31's Avatar
    Join Date
    03-02-2011
    Location
    Dammam, Saudi Arabia
    MS-Off Ver
    Office 365
    Posts
    452

    Re: Sum product, logical help

    SUMPRODUCT(--('Contest Effectiveness 2011'!$I$10:$I$137='Summary 2011'!J$16),--('Contest Effectiveness 2011'!$P$10:$P$137>=0%),--('Contest Effectiveness 2011'!$P$10:$P$137<=9.99%))

  3. #3
    Forum Contributor
    Join Date
    11-26-2010
    Location
    usa
    MS-Off Ver
    Office 365
    Posts
    1,233

    Re: Sum product, logical help

    hey, thxs alot! cheers

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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