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