Thread: Counting cells between ranges
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Max Max is offline
external usenet poster
  
Posts: 9,221
Default Counting cells between ranges
"Jason30" wrote:
How do I count the number of cells
that have values between for example $1000 and $2000?

One way is to use 2 countifs ..
Assuming source data in col A, placed in say, B1:
=COUNTIF(A:A,"=1000")-COUNTIF(A:A,"2000")
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
Reply With QuoteReply With Quote