Sumif help...

J

Jambruins

In column R I have numbers (negative and positive). I would like a formula
to sum all of the corresponding numbers in column X if column R is between
-.5 and .5. Then another formula to do the same but between .5 and .9
(including -.5 and -.9 either incorporate the absolute value command here or
use greater than less than with an or funciton). Any ideas? Thanks
 
T

Tom Ogilvy

=sumproduct(--(Abs(R1:R2000<.5),X1:X2000)
=sumproduct(--abs(R1:R2000>=.5),--abs(R1:R2000<=.9),X1:X2000)
 
Top