Results 1 to 3 of 3
  1. #1
    New Lounger
    Join Date
    Jun 2006
    Posts
    13
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Excel sum conditon (excel 2000)

    Hi woodys lounge!

    I am having trouble figuring out ghow do solve a problem using excel.

    by problem is summing a range only if it has not been discounted prior to the totalling

    attached is a workbook.

    a little explanation:

    Column C in Line by line discount % for each item
    in this case the ball is discounted at 10 % before the discount subtotal
    all other items are discounted at 45% at the discount subtotal but because the ball already has a discount it should not be included in the subtotal discount of 45% it should be added after the discount is applied to the items that dont have the line discount

    any Ideas on how I can do this in excel?

    Thanks

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Excel sum conditon (excel 2000)

    =SUMPRODUCT(F2:F4,(C2:C4=0)*1)*(1-B8)+SUMPRODUCT(F2:F4,(C2:C4<>0)*1,1-C2:C4)

    Steve

  3. #3
    New Lounger
    Join Date
    Jun 2006
    Posts
    13
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Excel sum conditon (excel 2000)

    thank you

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •