Sumif help...

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel 2002 : How to sum range ? 10
Shorter Formula 1
Sumif number is greater than a number but less than another number 2
SUMPRODUCT help needed 4
Help With Nested SumIf / Or 3
Sumif ">today()" 1
sumif within a range 1
sumif problem 5

Back
Top