Remember Me?

#1
November 7th 04, 07:44 PM
 nobrabbit Posts: n/a
Group by count formula

Working with vehicle reservations, I need to determine how many times a
certain model vehicle is reserved. For example, I have a column titled
"model" where the reservationist can put in Taurus, Windstar, etc. I
need to chart the data showing the models by group and then how many
times the vehicle within that group was reserved. Ex: one axis would
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 group
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.

--
nobrabbit
------------------------------------------------------------------------
nobrabbit's Profile: http://www.excelforum.com/member.php...o&userid=16177

#2
November 7th 04, 09:10 PM
 Ken Wright Posts: n/a

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

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------

"nobrabbit" wrote in message
...

Working with vehicle reservations, I need to determine how many times a
certain model vehicle is reserved. For example, I have a column titled
"model" where the reservationist can put in Taurus, Windstar, etc. I
need to chart the data showing the models by group and then how many
times the vehicle within that group was reserved. Ex: one axis would
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 group
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.

--
nobrabbit
------------------------------------------------------------------------
nobrabbit's Profile:
http://www.excelforum.com/member.php...o&userid=16177

---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.788 / Virus Database: 533 - Release Date: 01/11/2004

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post Bill_S Excel Discussion (Misc queries) 3 January 20th 05 10:41 PM Slainteva Excel Discussion (Misc queries) 2 January 19th 05 08:25 PM Molly F Excel Discussion (Misc queries) 2 January 19th 05 06:15 PM Seti Excel Discussion (Misc queries) 3 December 9th 04 09:25 PM Mimi Excel Worksheet Functions 0 November 5th 04 11:55 AM

All times are GMT +1. The time now is 03:49 AM.