How to Count for each category

Hi Aaron,

The formula solution is second best to a pivot table, but sure - you can do this in XL 2003 (you attached an XLS file) using SUMPRODUCT.

For ease, I put the lower/upper limit for each category in a spare cell.

=SUMPRODUCT(--($B$5:$B$12=$F5),--($C$5:$C$12>=G$1),--($C$5:$C$12<=G$2))

If you can use solely an XLSX file then use SUMIFS instead of SUMPRODUCT - it calculates more efficiently.