<div>
try<br />
<br />
=countifs(A1:A14,&quot;&gt;&quot; &amp;&nbsp;B1,A1:A14,&quot;&lt;&quot; &amp;&nbsp;B2)
</div>


try

=countifs(A1:A14,">" & B1,A1:A14,"<" & B2)

<div>
Another option is to run a pivot table with your numbers as row fields, grouped by 10000, and your numbers as data field with a count. <br />
<br />
T
</div>


Another option is to run a pivot table with your numbers as row fields, grouped by 10000, and your numbers as data field with a count.

T

<div>
<div class="content wysiwyg-content">
<br />
I want to plot the distribution of column A having 14 numbers by counting into buckets in column B<br />
ColA &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;ColB<br />
&nbsp;421,006 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 400,000 <br />
&nbsp;432,070 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 410,000 <br />
&nbsp;436,415 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 420,000 <br />
&nbsp;438,019 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 430,000 <br />
&nbsp;443,280 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 440,000 <br />
&nbsp;443,375 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 450,000 <br />
&nbsp;446,952 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 460,000 <br />
&nbsp;447,806 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 470,000 <br />
&nbsp;449,127 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<br />
&nbsp;449,967 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<br />
&nbsp;450,260 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<br />
&nbsp;463,056 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<br />
&nbsp;463,435 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<br />
&nbsp;463,767 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<br />
<br />
<br />
<br />
What is wrong with this formula?<br />
<br />
=countifs(A1:A14,&gt;B1,A1:A1<wbr />4,&lt;B2)
</div>
</div>



I want to plot the distribution of column A having 14 numbers by counting into buckets in column B
ColA          ColB
 421,006 	 400,000 
 432,070 	 410,000 
 436,415 	 420,000 
 438,019 	 430,000 
 443,280 	 440,000 
 443,375 	 450,000 
 446,952 	 460,000 
 447,806 	 470,000 
 449,127 	
 449,967 	
 450,260 	
 463,056 	
 463,435 	
 463,767 	



What is wrong with this formula?

=countifs(A1:A14,>B1,A1:A14,<B2)

Countifs

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.