Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
formula
Im writing a horse race program.
I can do as many as 20 horses in one race (or 20 rows) In my program there are 15 categories (or 15 columns) where a horse can be rated 1st, 2nd or 3rd which is conditionally formatted (Blue, Red and Green). In other words a particular horse could have any number of blue, reds, or greens in his section up to 15.. Id like to be able to break this down to the point where I can generate a number for each horse, corresponding to how many 1st, 2nd, or 3rds(blue, reds and greens) a horse may have. What formula would I use to count all the blues, reds and greens for each horse and generate this into another section of my sheet? -- SAlexander |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
formula
Assuming your cells contain 1, 2 or 3 in the cell, just use a countif statement =countif(range,1) will tell you how many 1's etc -- Mallycat ------------------------------------------------------------------------ Mallycat's Profile: http://www.excelforum.com/member.php...o&userid=35514 View this thread: http://www.excelforum.com/showthread...hreadid=555169 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
formula
Sorry to trouble you but your assumption is not right. The numbers are not 1,
2 and 3 If the number 1 horse has the best time out of the other 20 horses the number will be 1 in blue 2nd best the number will be 1 in red and 3rd green I would like to separate Theses 1s and count all the blues reds and greens. -- SAlexander "Mallycat" wrote: Assuming your cells contain 1, 2 or 3 in the cell, just use a countif statement =countif(range,1) will tell you how many 1's etc -- Mallycat ------------------------------------------------------------------------ Mallycat's Profile: http://www.excelforum.com/member.php...o&userid=35514 View this thread: http://www.excelforum.com/showthread...hreadid=555169 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Match then lookup | Excel Worksheet Functions | |||
Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
Creating a check mark box | Setting up and Configuration of Excel | |||
Match / Vlookup within an Array formula | Excel Discussion (Misc queries) |