Conditional Sum (In Need of an Excel Guru)

  • Thread starter Thread starter Steve Klenner
  • Start date Start date
S

Steve Klenner

I'm not sure how to pull this off...I will make explanation as simple as
possible.

I have worksheet 1 (WS 1) that calc's our sell price from manufacturers
list..it consists of:
Column 1 = Manufacturers List
Column 2 = Our Disc on that particular Piece
Column 3 = Calc's Column 1 & 2 for our cost
Column 4 = Our Markup % for that piece
Column 5 = Calcs Column 3 & 4 for our sell price

A second worksheet (WS 2)has the following:
Column 1 = User inputs Qty's desired for that part
Column 2 = Part Desc
Column 3 = Unit cost from column 5 of 1st worksheet
Column 4 = Calc's Column 1 & 3 for total cost for that part

I want to total (sum) all items for column 4 of (WS 2)... ONLY if column 2
for each part in (WS 1) is NOT 0% discount.

In other words I only want to total parts in (WS 2) column 4 if the
corresponding part in (WS 1) column 2 is NOT 0% discount.

Sorry for the lengthy description...but is this even possible?

Steve
 
Steve,

I'm not sure that I follow you exactly and what is confusing me is that
there does not seem to be a need for a product # so I am going to assume
that somewhere you need to add that and as such require a sum based on
multiple criteria, which you can perform with

SUMPRODUCT(("first criteria range"<>0)*("second criteria
range"=Partdesc)*(range you want to sum))

Sorry I couldn't be more clear on the references but I hope you will get the
idea.

PC
 
Back
Top