Thread: Formula to show =500 but +<1000 in one column
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Mike H Mike H is offline
external usenet poster
  
Posts: 11,501
Default 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.
Reply With QuoteReply With Quote