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

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

.