Numbering data as entered
 

I am entering names of clients as we enrolled them in our program. Is it
possible to have a formula in a column next to the column where I enter the
names, so it will automatically show the number. I would like to be able to
see how many clients we have enrolled. Besides I will use the total number
to another worksheet as a summary.

Example is if I use column B from row 1 down for entering clients' name, I
would like to use column A to number the client as I enter it. Instead of me
numbering column A manually, I would like column A (from row 1 down) to have
formula that number will automatically show as I enter names in column B.

Please help if this is possible.

Numbering data as entered
 

in A1 enter this

=IF(B1="","",1)

in A2 enter this

=IF(B2="","",A1+1)

Drag A2 down as far as you want.

Does that help?


"Irene" wrote in message
...
I am entering names of clients as we enrolled them in our program. Is it
possible to have a formula in a column next to the column where I enter
the
names, so it will automatically show the number. I would like to be able
to
see how many clients we have enrolled. Besides I will use the total
number
to another worksheet as a summary.

Example is if I use column B from row 1 down for entering clients' name, I
would like to use column A to number the client as I enter it. Instead of
me
numbering column A manually, I would like column A (from row 1 down) to
have
formula that number will automatically show as I enter names in column B.

Please help if this is possible.

Numbering data as entered
 

In A1 enter:

=IF(B1="","",ROW()) and copy down
--
Gary''s Student - gsnu200795


"Irene" wrote:

I am entering names of clients as we enrolled them in our program. Is it
possible to have a formula in a column next to the column where I enter the
names, so it will automatically show the number. I would like to be able to
see how many clients we have enrolled. Besides I will use the total number
to another worksheet as a summary.

Example is if I use column B from row 1 down for entering clients' name, I
would like to use column A to number the client as I enter it. Instead of me
numbering column A manually, I would like column A (from row 1 down) to have
formula that number will automatically show as I enter names in column B.

Please help if this is possible.

Numbering data as entered
 

That was quick. Thanks very much, you make my life easier.

"Gaurav" wrote:

in A1 enter this

=IF(B1="","",1)

in A2 enter this

=IF(B2="","",A1+1)

Drag A2 down as far as you want.

Does that help?


"Irene" wrote in message
...
I am entering names of clients as we enrolled them in our program. Is it
possible to have a formula in a column next to the column where I enter
the
names, so it will automatically show the number. I would like to be able
to
see how many clients we have enrolled. Besides I will use the total
number
to another worksheet as a summary.

Example is if I use column B from row 1 down for entering clients' name, I
would like to use column A to number the client as I enter it. Instead of
me
numbering column A manually, I would like column A (from row 1 down) to
have
formula that number will automatically show as I enter names in column B.

Please help if this is possible.

Numbering data as entered
 

have another question, is it possible to sum up the names. I would like to
sum up somewhere down the row as name is entered. Or a cell that sum up the
number I have in column A. I have to link this total to another worksheet.

Appreciate more help.

"Gaurav" wrote:

in A1 enter this

=IF(B1="","",1)

in A2 enter this

=IF(B2="","",A1+1)

Drag A2 down as far as you want.

Does that help?


"Irene" wrote in message
...
I am entering names of clients as we enrolled them in our program. Is it
possible to have a formula in a column next to the column where I enter
the
names, so it will automatically show the number. I would like to be able
to
see how many clients we have enrolled. Besides I will use the total
number
to another worksheet as a summary.

Example is if I use column B from row 1 down for entering clients' name, I
would like to use column A to number the client as I enter it. Instead of
me
numbering column A manually, I would like column A (from row 1 down) to
have
formula that number will automatically show as I enter names in column B.

Please help if this is possible.

Numbering data as entered
 

=COUNT(A:A)
with either Gaurav's post or mine
--
Gary''s Student - gsnu200795


"Irene" wrote:

have another question, is it possible to sum up the names. I would like to
sum up somewhere down the row as name is entered. Or a cell that sum up the
number I have in column A. I have to link this total to another worksheet.

Appreciate more help.

"Gaurav" wrote:

in A1 enter this

=IF(B1="","",1)

in A2 enter this

=IF(B2="","",A1+1)

Drag A2 down as far as you want.

Does that help?


"Irene" wrote in message
...
I am entering names of clients as we enrolled them in our program. Is it
possible to have a formula in a column next to the column where I enter
the
names, so it will automatically show the number. I would like to be able
to
see how many clients we have enrolled. Besides I will use the total
number
to another worksheet as a summary.

Example is if I use column B from row 1 down for entering clients' name, I
would like to use column A to number the client as I enter it. Instead of
me
numbering column A manually, I would like column A (from row 1 down) to
have
formula that number will automatically show as I enter names in column B.

Please help if this is possible.

Numbering data as entered
 

Thank you very much! It helps.

"Gary''s Student" wrote:

=COUNT(A:A)
with either Gaurav's post or mine
--
Gary''s Student - gsnu200795


"Irene" wrote:

have another question, is it possible to sum up the names. I would like to
sum up somewhere down the row as name is entered. Or a cell that sum up the
number I have in column A. I have to link this total to another worksheet.

Appreciate more help.

"Gaurav" wrote:

in A1 enter this

=IF(B1="","",1)

in A2 enter this

=IF(B2="","",A1+1)

Drag A2 down as far as you want.

Does that help?


"Irene" wrote in message
...
I am entering names of clients as we enrolled them in our program. Is it
possible to have a formula in a column next to the column where I enter
the
names, so it will automatically show the number. I would like to be able
to
see how many clients we have enrolled. Besides I will use the total
number
to another worksheet as a summary.

Example is if I use column B from row 1 down for entering clients' name, I
would like to use column A to number the client as I enter it. Instead of
me
numbering column A manually, I would like column A (from row 1 down) to
have
formula that number will automatically show as I enter names in column B.

Please help if this is possible.

Numbering data as entered
 

=COUNTA(B:B) entered in C1 will give a count of names in column B

In the other worksheet =COUNTA(Sheet1!B:B)


Gord Dibben MS Excel MVP

On Tue, 15 Jul 2008 09:44:02 -0700, Irene
wrote:

have another question, is it possible to sum up the names. I would like to
sum up somewhere down the row as name is entered. Or a cell that sum up the
number I have in column A. I have to link this total to another worksheet.

Appreciate more help.

"Gaurav" wrote:

in A1 enter this

=IF(B1="","",1)

in A2 enter this

=IF(B2="","",A1+1)

Drag A2 down as far as you want.

Does that help?


"Irene" wrote in message
...
I am entering names of clients as we enrolled them in our program. Is it
possible to have a formula in a column next to the column where I enter
the
names, so it will automatically show the number. I would like to be able
to
see how many clients we have enrolled. Besides I will use the total
number
to another worksheet as a summary.

Example is if I use column B from row 1 down for entering clients' name, I
would like to use column A to number the client as I enter it. Instead of
me
numbering column A manually, I would like column A (from row 1 down) to
have
formula that number will automatically show as I enter names in column B.

Please help if this is possible.