Group by count formula

[nobrabbit]

Working with vehicle reservations, I need to determine how many times
certain model vehicle is reserved. For example, I have a column title
"model" where the reservationist can put in Taurus, Windstar, etc.
need to chart the data showing the models by group and then how man
times the vehicle within that group was reserved. Ex: one axis woul
chart the different groups and the other the count within the group.

That's all I need to chart; the group and the count within the grou
and I'm having a heck of time trying to figure out a formula for it
Thanks for any insight you guys can give me, nobrabbit

 

[Ken Wright]

You should really do yourself the favour of looking at Pivot tables

http://peltiertech.com/Excel/Pivots/pivotstart.htm

Failing that check out the SUMPRODUCT function for counting/summing more than
one criteria

http://www.xldynamic.com/source/xld.SUMPRODUCT.html