Not exactly. There is no sum. The only mathematical operation is the
product of the if statement multipled by J6.

If you need a better explanation, I think I'm SOL. The explanation I gave
is pretty much the only way I can describe it. If you absolutely do need a
better explanation, I can do my best.

"Peo Sjoblom" wrote:

Do you want to add O6<A3:A39*J6 and O6=A3:A39*0.14?
If so

=(SUMIF(A3:A39,"<"&O6,B3:B39)*J6)+(SUMIF(A3:A39," ="&O6,B3:B39)*0.14)


Regards,

Peo Sjoblom

"Currie" wrote:

What I'm trying to do is something like:

=J6*if(O6<{A3:A39},{B3:B39},.14)

What it pretty much is is that if O6 is less than some percentage {A3:A39},
then multiple the corresponding dollar amount {B3:B39} by J6, and if it is
greater than the % in B39, then multiple J6 by .14 .... so I want 27.15% * .09

If anyone knows what the **** I'm talking about, you get a cookie!! And if
you can answer my questions, you get another cookie!! Any help would be
appreciated!!