Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
COUNTIF with extension
Actually, you might be able to use CSE formulas to do this. Assuming
your data is in A1:B5. You could use the following formula: =SUM(IF(A$1:A$5=D2,IF(B$1:B$5<E1,1,0))) Cell D2 has the color you're trying to count (e.g. White) and cell E1 has the cutoff date. When you enter the formula, you have to use Control+Shift+Enter to enter it as an array formula. Use this formula in 3 different cells...1 for each unique color. On Wed, 27 Aug 2003 10:58:20 -0700, "Simon" wrote: I think some programming is needed for what I require, because I counld not find any functions to achieve it. White 10/02/03 Blue 11/02/03 Red 12/02/03 Red 12/07/03 White 12/07/03 I need a function to tell me for each colour who many have dates before 01/06/03. So producing a function that I pass the String of the colour and a set date (01/06/03) and it returns the number of occurances of that colour before the specified date. Hopefully I have made it clear what required of the function. I hope some will have some idea. Many Thanks |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
COUNTIF with extension
Thank you, this worked great.
-----Original Message----- Actually, you might be able to use CSE formulas to do this. Assuming your data is in A1:B5. You could use the following formula: =SUM(IF(A$1:A$5=D2,IF(B$1:B$5<E1,1,0))) Cell D2 has the color you're trying to count (e.g. White) and cell E1 has the cutoff date. When you enter the formula, you have to use Control+Shift+Enter to enter it as an array formula. Use this formula in 3 different cells...1 for each unique color. On Wed, 27 Aug 2003 10:58:20 -0700, "Simon" wrote: I think some programming is needed for what I require, because I counld not find any functions to achieve it. White 10/02/03 Blue 11/02/03 Red 12/02/03 Red 12/07/03 White 12/07/03 I need a function to tell me for each colour who many have dates before 01/06/03. So producing a function that I pass the String of the colour and a set date (01/06/03) and it returns the number of occurances of that colour before the specified date. Hopefully I have made it clear what required of the function. I hope some will have some idea. Many Thanks . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
xlsx extension | Excel Discussion (Misc queries) | |||
.xls Extension | Excel Discussion (Misc queries) | |||
Transformation d'images avec une extension .jpg ou .jpeg en images avec extension .bmp ou .ico | Excel Discussion (Misc queries) | |||
.xlb extension | Excel Discussion (Misc queries) | |||
xls extension | Excel Discussion (Misc queries) |