Nested Countif??

  • Thread starter Thread starter rajudayma
  • Start date Start date
R

rajudayma

Dear Mates,
I want to calculate the count in ranges in excel. For example, in th
range A1:A50, I want to list the number of cells in the followin
format

Range Count
----------------- ------------
0 AND <=10 10
10 And <=20 5
20 And <=50 35
Click to expand...

Could some one help me here please.

Thanks in advance.

Rajendr
 
Hi

one way

assuming answer in B1 =countif($A$1:$A$50,"<="&10)
then B2 = countif($A$1:$A$50,"<="&20)-B1
B3 = countif($A$1:$A$50,"<="&30)-B2-B1
or = countif($A$1:$A$50,"<="&30)-
countif($A$1:$A$50,"<="&20)
etc
 
or

=SUMPRODUCT((A1:A50>0)*(A1:A50<=10))
=SUMPRODUCT((A1:A50>10)*(A1:A50<=20))
etc.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

JulieD said:
Hi

one way

assuming answer in B1 =countif($A$1:$A$50,"<="&10)
then B2 = countif($A$1:$A$50,"<="&20)-B1
B3 = countif($A$1:$A$50,"<="&30)-B2-B1
or = countif($A$1:$A$50,"<="&30)-
countif($A$1:$A$50,"<="&20)
etc
Click to expand...
 
Back
Top