Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
need formula to count cells below | Excel Discussion (Misc queries) | |||
Formula to count the cells in a range that have a fill color. | Excel Discussion (Misc queries) | |||
Formula to count the cells in a range that have a fill color. | Excel Discussion (Misc queries) | |||
count formula between worksheets | Excel Discussion (Misc queries) | |||
Count If Formula | Excel Worksheet Functions |