Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old November 7th 04, 07:44 PM
nobrabbit
 
Posts: n/a
Default 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
View this thread: http://www.excelforum.com/showthread...hreadid=276064


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

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
View this thread: http://www.excelforum.com/showthread...hreadid=276064



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




Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
need formula to count cells below Bill_S Excel Discussion (Misc queries) 3 January 20th 05 10:41 PM
Formula to count the cells in a range that have a fill color. Slainteva Excel Discussion (Misc queries) 2 January 19th 05 08:25 PM
Formula to count the cells in a range that have a fill color. Molly F Excel Discussion (Misc queries) 2 January 19th 05 06:15 PM
count formula between worksheets Seti Excel Discussion (Misc queries) 3 December 9th 04 09:25 PM
Count If Formula Mimi Excel Worksheet Functions 0 November 5th 04 11:55 AM


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

Powered by vBulletin® Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
Copyright 2004-2017 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017