I'm trying to write a formula to produce results such as:

AA 1
BB 0
BB 0
AA 2
AA 3
BB 0
AA 4
CC 0

Column A is a (drop-down) data validated list of 'AA,BB,CC'.
Column B is the counter cell.

Every 'AA' increments a counter, anything not 'AA' yields a 0.

I've tried using the countif but it seems to give me a sum rather than what I'm looking for, at least to what I understand its use of from the help.

Is this possible in a formula? I'd rather not have to use VBA code if at all possible.

hi,

=IF(A1="AA",COUNTIF($A$1:A1,"AA"),0)

and fill down

isabelle


Le 2013-07-09 21:03, User a écrit :
I'm trying to write a formula to produce results such as:

AA 1
BB 0
BB 0
AA 2
AA 3
BB 0
AA 4
CC 0

Column A is a (drop-down) data validated list of 'AA,BB,CC'.
Column B is the counter cell.

Every 'AA' increments a counter, anything not 'AA' yields a 0.

I've tried using the countif but it seems to give me a sum rather than what I'm looking for, at least to what I understand its use of from the help.

Is this possible in a formula? I'd rather not have to use VBA code if at all possible.

On Tue, 09 Jul 2013 21:37:20 -0400, isabelle wrote:

Thanks so much. This worked perfect. I was missing the anchor $A$1,
never thought of that!

hi,

=IF(A1="AA",COUNTIF($A$1:A1,"AA"),0)

and fill down

isabelle


Le 2013-07-09 21:03, User a écrit :
I'm trying to write a formula to produce results such as:

AA 1
BB 0
BB 0
AA 2
AA 3
BB 0
AA 4
CC 0

Column A is a (drop-down) data validated list of 'AA,BB,CC'.
Column B is the counter cell.

Every 'AA' increments a counter, anything not 'AA' yields a 0.

I've tried using the countif but it seems to give me a sum rather than what I'm looking for, at least to what I understand its use of from the help.

Is this possible in a formula? I'd rather not have to use VBA code if at all possible.