# Thread: Excel sum conditon (excel 2000)

1. ## 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. ## 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. ## 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
•