Formula to show =>500 but +<1000 in one column

  • Thread starter Thread starter rahji
  • Start date Start date
R

rahji

I can find a formula to calculate one, but not both - can anyone help? Many
thanks.
 
What do you mean to 'show' numbers? add them up?

Try this

=SUMPRODUCT((A1:A20>=500)*(A1:A20<=1000)*(A1:A20))

Mike
 
Your question is open to some interpretation. You may want something like this

=IF(AND(A1>=500,A1<1000),A1,NA())
 
Thanks Mike - I have a list of numbers, and I want to have a total of numbers
over 500 but less than 1000.
 
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 Assistance with Fomula 0
Access Running Balance in Access 1
Help on IF please! 6
Urgent help on IF please! 6
Excel Formulas Treated as Strings 1
Formula for getting the breakup of net amount 1
ListObjects - VBA code that worked in previous versions of Excel doesnot work in Excel 2013 2
Autofill a dynamic range with a formula. 1

Back
Top