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.

[TABLE="width: 165"]
<TBODY>[TR]
[TD="colspan: 2"]Range</SPAN>[/TD]
[/TR]
[TR]
[TD]$0.00 </SPAN>[/TD]
[TD]$4,999.00 </SPAN>[/TD]
[/TR]
[TR]
[TD]$5,000.00 </SPAN>[/TD]
[TD]$9,999.00 </SPAN>[/TD]
[/TR]
[TR]
[TD]$10,000.00 </SPAN>[/TD]
[TD]$14,999.00 </SPAN>[/TD]
[/TR]
[TR]
[TD]$15,000.00 </SPAN>[/TD]
[TD]$19,999.00 </SPAN>[/TD]
[/TR]
[TR]
[TD]$20,000.00 </SPAN>[/TD]
[TD]$24,999.00 </SPAN>[/TD]
[/TR]
[TR]
[TD]$25,000.00 </SPAN>[/TD]
[TD]$29,999.00 </SPAN>[/TD]
[/TR]
[TR]
[TD]$30,000.00 </SPAN>[/TD]
[TD]$34,999.00 </SPAN>[/TD]
[/TR]
[TR]
[TD]$35,000.00 </SPAN>[/TD]
[TD]$39,999.00 </SPAN>[/TD]
[/TR]
[TR]
[TD]$40,000.00 </SPAN>[/TD]
[TD]$44,999.00 </SPAN>[/TD]
[/TR]
[TR]
[TD]$45,000.00 </SPAN>[/TD]
[TD]$49,999.00 </SPAN>[/TD]
[/TR]
[TR]
[TD]$50,000.00 </SPAN>[/TD]
[TD]$54,999.00 </SPAN>[/TD]
[/TR]
[TR]
[TD]$55,000.00 </SPAN>[/TD]
[TD]$59,999.00 </SPAN>[/TD]
[/TR]
[TR]
[TD]$60,000.00 </SPAN>[/TD]
[TD]$64,999.00 </SPAN>[/TD]
[/TR]
[TR]
[TD]$65,000.00 </SPAN>[/TD]
[TD]$69,999.00 </SPAN>[/TD]
[/TR]
[TR]
[TD]$70,000.00 </SPAN>[/TD]
[TD]$74,999.00 </SPAN>[/TD]
[/TR]
[TR]
[TD]$75,000.00 </SPAN>[/TD]
[TD]$79,999.00 </SPAN>[/TD]
[/TR]
[TR]
[TD]$80,000.00 </SPAN>[/TD]
[TD]$84,999.00 </SPAN>[/TD]
[/TR]
[TR]
[TD]$85,000.00 </SPAN>[/TD]
[TD]$89,999.00 </SPAN>[/TD]
[/TR]
[TR]
[TD]$90,000.00 </SPAN>[/TD]
[TD]$94,999.00 </SPAN>[/TD]
[/TR]
[TR]
[TD]$95,000.00 </SPAN>[/TD]
[TD]$99,999.00 </SPAN>[/TD]
[/TR]
[TR]
[TD]$100,000.00 </SPAN>[/TD]
[TD] [/TD]
[/TR]
</TBODY><COLGROUP><COL span=2></COLGROUP>[/TABLE]

 

[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.