sumif query

[Christopherdj]

I have the following formula:

Please Login or Register  to view this content.

which means if R2 is less than Q2 then multiply R2 x U2 x V2, and if not then multiply O2 x T2 x U2 x V2

I've done something strage (again), please help.

thanks

[NBVC]

No need for SUM... just IF

=IF(r2<Q2,o2*R2*U2*V2,O2*T2*U2*V2)

[Christopherdj]

Thanks again for your help. It is late here - after 3am and I just couldn't sleep because this complex payment system I'm working on has been doing my head in.
But on a brighter note, I got most formulas myself, and this site helped me so quickly with the rest. What a great helpfull place this is.

[ben_hensel]

What you're describing is a regular IF(), not SUMIF()

what you're describing with "which means" is something like,

Please Login or Register  to view this content.

But that is not how SUMIF() thinks.

SUMIF() takes the form:

SUMIF( range test, conditional test, range to sum )

(range to sum is implicitly the ranged tested if the third array isn't entered),

and it adds, not multiplies.

What do you WANT the formula to do?