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

I can find a formula to calculate one, but not both - can anyone help? Many
thanks.
--
In need of help.

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

What do you mean to 'show' numbers? add them up?

Try this

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

Mike

"rahji" wrote:

I can find a formula to calculate one, but not both - can anyone help? Many
thanks.
--
In need of help.

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

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

=IF(AND(A1=500,A1<1000),A1,NA())


--
HTH,
Barb Reinhardt

If this post was helpful to you, please click YES below.



"rahji" wrote:

I can find a formula to calculate one, but not both - can anyone help? Many
thanks.
--
In need of help.

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

Thanks Mike - I have a list of numbers, and I want to have a total of numbers
over 500 but less than 1000.
--
In need of help.


"Mike H" wrote:

What do you mean to 'show' numbers? add them up?

Try this

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

Mike

"rahji" wrote:

I can find a formula to calculate one, but not both - can anyone help? Many
thanks.
--
In need of help.