Countif

[johns99]

Trying to setup a formula that will count the amount of bonuses that fall within a specific range...for example

Count if the bonus ranges from $0-$4999...suggestions?

thanks in advance.

Range</SPAN>
$0.00 </SPAN>	$4,999.00 </SPAN>
$5,000.00 </SPAN>	$9,999.00 </SPAN>
$10,000.00 </SPAN>	$14,999.00 </SPAN>
$15,000.00 </SPAN>	$19,999.00 </SPAN>
$20,000.00 </SPAN>	$24,999.00 </SPAN>
$25,000.00 </SPAN>	$29,999.00 </SPAN>
$30,000.00 </SPAN>	$34,999.00 </SPAN>
$35,000.00 </SPAN>	$39,999.00 </SPAN>
$40,000.00 </SPAN>	$44,999.00 </SPAN>
$45,000.00 </SPAN>	$49,999.00 </SPAN>
$50,000.00 </SPAN>	$54,999.00 </SPAN>
$55,000.00 </SPAN>	$59,999.00 </SPAN>
$60,000.00 </SPAN>	$64,999.00 </SPAN>
$65,000.00 </SPAN>	$69,999.00 </SPAN>
$70,000.00 </SPAN>	$74,999.00 </SPAN>
$75,000.00 </SPAN>	$79,999.00 </SPAN>
$80,000.00 </SPAN>	$84,999.00 </SPAN>
$85,000.00 </SPAN>	$89,999.00 </SPAN>
$90,000.00 </SPAN>	$94,999.00 </SPAN>
$95,000.00 </SPAN>	$99,999.00 </SPAN>
$100,000.00 </SPAN>

<TBODY>
</TBODY><COLGROUP><COL span=2></COLGROUP>

 

[derek.hughes]

I think a much easier way to do this would be to skip the formulas altogether and just use a pivot table and then "Group" the results. Check out Tip #6 on this page - it will be a lot easier and faster.

10 Helpful Excel PivotTable Tips For Quick & Efficient Data Analyis

 

[bbott]

Try this in cell I3:

=COUNTIFS(E:E,">"&G3,E:E,"<="&H3)

Copy down.