Multiply based on criteria

[gj7592]

Hi,

I need to do a multiplication based on certain criteria.

So in reference to the sample file; what I need is to get a multiplication outcome for column C(weight).
The criteria is that column A(serial No.) should be checked for columnB(unit volume) greather than or equal to 1, any unit volume greater than 1 should be multiplied by the corresponding Serial No.(column A) and matching unit volume 1.

For instance,
cell C3 should be cell B3*C2
cell C16 should be cell B16*C14.

[AskMeAboutExcel]

Try this in cell D2:

Please Login or Register  to view this content.

[gj7592]

Hi

Thank you this is what I was looking for.
Could you please break down the formula if you don't mind, I'm trying to make it work it work with the actual file I have and I just can't seem to get it to work because I'm not sure how to refer the cells that I require using this formula.

[AliGW]

If you interrogate the formula in the formula bar, you will see the cells and ranges highlighted. Anything with @ is a single cell refrence, without is a range. It resolves to this:

=(B2>1)*B2*SUMIF($A$2:$A$25,A2,$C$2:$C$25)

[gj7592]

Thank you @AliGW for the clarification, it helped me a lot