Sumif help...
 

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

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

--
Regards,
Tom Ogilvy



"Jambruins" wrote in message
...
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