|  | Carry running total for various items? | | |
| | | Ed from AZ |  |
|  Posted: Wed Jun 04, 2008 11:02 pm Post subject: Carry running total for various items? |  |
In Col A, I have a drop-down (data validation) of five items. In Col
B, I need to put a number that is a running total of how many times
the item in Col A has been selected. So it would look like:
Col A Col B
A 1
A 2
A 3
B 1
B 2
A 4
A 5
C 1
C 2
D 1
D 2
D 3
A 6
B 3
Is there a formula I can use?
Ed |
| |
| | | Rick Rothstein (MVP - VB) | |
| | Posted: Wed Jun 04, 2008 11:02 pm Post subject: Re: Carry running total for various items? | |
Assuming your first value is in Row 1...
=COUNTIF(A$1:A1,A1)
Rick
"Ed from AZ" <prof_ofwhat@yahoo.com> wrote in message
news:dbde7dd7-a854-4138-968d-f0b30f4dee9f@m44g2000hsc.googlegroups.com...
| Quote: | In Col A, I have a drop-down (data validation) of five items. In Col
B, I need to put a number that is a running total of how many times
the item in Col A has been selected. So it would look like:
Col A Col B
A 1
A 2
A 3
B 1
B 2
A 4
A 5
C 1
C 2
D 1
D 2
D 3
A 6
B 3
Is there a formula I can use?
Ed |
|
| |
| | | JP | |
| | Posted: Wed Jun 04, 2008 11:24 pm Post subject: Re: Carry running total for various items? | |
Let's say your data starts in A1, put this formula in B2 and fill
down:
=COUNTIF($A$1:$A2,A2)
You can't use it in B1, however.
--JP
On Jun 4, 7:02 pm, Ed from AZ <prof_ofw...@yahoo.com> wrote:
| Quote: | In Col A, I have a drop-down (data validation) of five items. In Col
B, I need to put a number that is a running total of how many times
the item in Col A has been selected. So it would look like:
Col A Col B
A 1
A 2
A 3
B 1
B 2
A 4
A 5
C 1
C 2
D 1
D 2
D 3
A 6
B 3
Is there a formula I can use?
Ed |
|
| |
| | | JP | |
| | Posted: Wed Jun 04, 2008 11:25 pm Post subject: Re: Carry running total for various items? | |
Sorry, Rick's formula is correct.
On Jun 4, 7:24 pm, JP <jp2...@earthlink.net> wrote:
| Quote: | Let's say your data starts in A1, put this formula in B2 and fill
down:
=COUNTIF($A$1:$A2,A2)
You can't use it in B1, however.
--JP |
|
| |
| | | Ed from AZ | |
| | Posted: Thu Jun 05, 2008 3:11 pm Post subject: Re: Carry running total for various items? | |
Thank you, Rick!! Greatly appreciated!
Ed
On Jun 4, 4:17 pm, "Rick Rothstein \(MVP - VB\)"
<rick.newsNO.S...@NO.SPAMverizon.net> wrote:
| Quote: | Assuming your first value is in Row 1...
=COUNTIF(A$1:A1,A1)
Rick
"Ed from AZ" <prof_ofw...@yahoo.com> wrote in messagenews:dbde7dd7-a854-4138-968d-f0b30f4dee9f@m44g2000hsc.googlegroups.com...
In Col A, I have a drop-down (data validation) of five items. In Col
B, I need to put a number that is a running total of how many times
the item in Col A has been selected. So it would look like:
Col A Col B
A 1
A 2
A 3
B 1
B 2
A 4
A 5
C 1
C 2
D 1
D 2
D 3
A 6
B 3
Is there a formula I can use?
Ed- Hide quoted text -
- Show quoted text - |
|
| |
|
|
