SUMIF Issue

Hello,
There is no attachment of image?

Hello,
This can be done with if + sum function. Please refer the attached excel for more insights.

Use this formula. BtW, images aren't much use. Attach an Excel sheet next time.

Unfortunately the attachment icon doesn't work at the moment. So, to attach an Excel file you have to do the following: Just before posting, scroll down to Go Advanced and then scroll down to Manage Attachments. Now follow the instructions at the top of that screen.

If your no of units is in A1:

=SUMPRODUCT(--(A1>{0,2000}),--(A1-{0,2000}),{120,-20})

The double negative (--), which is technically called the double unary operator, coerces TRUE and FALSE into ones and zeros: {0;1;0;0;1;0;1;0;0}

I'd use a simpler formula
=min(A1,2000)*100+max(A1-2000,0)*120

Fair point, xlnitwit... But I'd stick to mine, as it's very easily expandable to cover more than two price tiers...

I'd agree, if that's a likely scenario. If not, I prefer to keep things simple until such times as they need to be complicated.

Whatever....

Please close thread if you done with it.

There is no need for the thread to be closed.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.

sorry, instead of saying solved i said close.
please select Thread Tools from the menu link above and mark this thread as SOLVED.