Cell Counter/Increment


U

User

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.
 
Ad

Advertisements

I

isabelle

hi,

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

and fill down

isabelle


Le 2013-07-09 21:03, User a écrit :
 
Ad

Advertisements

P

Portunus

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top