Results 1 to 9 of 9

Add another Condition Column to Sumproduct formula

Threaded View

bdb1974 Add another Condition Column... 06-23-2009, 05:26 PM
JBeaucaire Re: Add another Condition... 06-23-2009, 05:30 PM
bdb1974 Re: Add another Condition... 06-23-2009, 05:57 PM
DonkeyOte Re: Add another Condition... 06-23-2009, 06:12 PM
bdb1974 Re: Add another Condition... 06-24-2009, 10:05 AM
DonkeyOte Re: Add another Condition... 06-24-2009, 10:19 AM
romperstomper Re: Add another Condition... 06-24-2009, 10:35 AM
DonkeyOte Re: Add another Condition... 06-24-2009, 10:37 AM
romperstomper Re: Add another Condition... 06-24-2009, 10:39 AM
  1. #1
    Forum Contributor
    Join Date
    12-10-2008
    Location
    Austin
    Posts
    660

    Add another Condition Column to Sumproduct formula

    This is my working formula
    =SUMPRODUCT(--($R$3:$R$28=88398),N$3:N$28,$P$3:$P$28)

    I want to make it an OR condition by having $R$3:$R$28=88676 as another option. I've tried the following formula.
    =SUMPRODUCT(-(IF($R$3:$R$28=88676,(O$3:O$28),1),IF($R$3:$R$28=88676,($P$3:$P$28),1)))
    and

    
    =SUMPRODUCT(OR(--($R$3:$R$28=88398),(--($S$3:$S$28=88398)),N$3:N$28,$P$3:$P$28))
    I'm getting a value error and can't figure out where the problem is.

    Any help is appreciated.

    Thanks,
    BDB
    Last edited by bdb1974; 06-23-2009 at 06:00 PM.

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