I can find a formula to calculate one, but not both - can anyone help? Many thanks.
R rahji Dec 21, 2008 #1 I can find a formula to calculate one, but not both - can anyone help? Many thanks.
M Mike H Dec 21, 2008 #2 What do you mean to 'show' numbers? add them up? Try this =SUMPRODUCT((A1:A20>=500)*(A1:A20<=1000)*(A1:A20)) Mike
What do you mean to 'show' numbers? add them up? Try this =SUMPRODUCT((A1:A20>=500)*(A1:A20<=1000)*(A1:A20)) Mike
B Barb Reinhardt Dec 22, 2008 #3 Your question is open to some interpretation. You may want something like this =IF(AND(A1>=500,A1<1000),A1,NA())
Your question is open to some interpretation. You may want something like this =IF(AND(A1>=500,A1<1000),A1,NA())
R rahji Dec 22, 2008 #4 Thanks Mike - I have a list of numbers, and I want to have a total of numbers over 500 but less than 1000.
Thanks Mike - I have a list of numbers, and I want to have a total of numbers over 500 but less than 1000.
