In excel counting cells in a range which meet condition ">Xand<X"

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm trying to construct a formula that will count the number of cells in a
range that meet the condition ">x and <x", (which I suppose is two conditions
in one really), where the range just contains numbers.
 
=SUMPRODUCT(--(rng>x),--(rng<y))

if it is really two values, but if as you show then

=SUMIF(rng,"<>"&x)

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)
 
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

IF OR AND in same conditional formula 2
Conditional Cell Formatting 5
count cells in a table that meet multiple criteria 1
Count contiguous cells, or count cell clusters 0
Excel VBA 1
Excel Conditional Formatting Removal 7
Conditional formatting on a dynamic range - workaround 1
Complex conditional summing - array COUNT works, array SUM gives#VALUE 4

Back
Top