I have a list of student names in Column A. They are grouped by class
period. The first row in each class period grouping has "Student Name" in
Column A. The subsequent rows have student names and then, after the last
student's name, there is a blank row. The periods have different number of
student in them. I need to put a formula in column G opposite the first name
in each period that will return the number of names in the period.

Example:
Column A Column G
Student Name
SAM Formula returns 4
GEORGE
SLIM
FRANK

Student Name
GEORGE Formula returns 3
ALLEN
HENRY


Student Name
etc

Any ideas would be welcome! Thanks.

Allen,
The =CountA formula will do this. =CountA will count all cells within the
range specified that contain any type of data.

Based on your example, let's say the first name for the first course is in
cell A2 and the last one is in cell A5. Based on that, enter the following
formula into cell G2:
=CountA(A2:A5)

The beginning cell of the count is the cell in which the first name is
entered for that course. The ending cell for the countA will be the last is
entered for that course.

If this response is helpful, click on Yes for "Was this post helpful to you?"

Linda



"Allen" wrote:

I have a list of student names in Column A. They are grouped by class
period. The first row in each class period grouping has "Student Name" in
Column A. The subsequent rows have student names and then, after the last
student's name, there is a blank row. The periods have different number of
student in them. I need to put a formula in column G opposite the first name
in each period that will return the number of names in the period.

Example:
Column A Column G
Student Name
SAM Formula returns 4
GEORGE
SLIM
FRANK

Student Name
GEORGE Formula returns 3
ALLEN
HENRY


Student Name
etc

Any ideas would be welcome! Thanks.

This was somewhat helpful. My problem is i want the formula to determine the
last cell to count...or, more specifically, the first row it comes to with a
blank cell. The classes are different sizes and I want each formula to start
with the row it's in (G2 for the first class) and count down until it finds a
Blank cell in Column A and count the number of students between that first
row and the blank row.

"ADB_Seeker" wrote:

Allen,
The =CountA formula will do this. =CountA will count all cells within the
range specified that contain any type of data.

Based on your example, let's say the first name for the first course is in
cell A2 and the last one is in cell A5. Based on that, enter the following
formula into cell G2:
=CountA(A2:A5)

The beginning cell of the count is the cell in which the first name is
entered for that course. The ending cell for the countA will be the last is
entered for that course.

If this response is helpful, click on Yes for "Was this post helpful to you?"

Linda



"Allen" wrote:

I have a list of student names in Column A. They are grouped by class
period. The first row in each class period grouping has "Student Name" in
Column A. The subsequent rows have student names and then, after the last
student's name, there is a blank row. The periods have different number of
student in them. I need to put a formula in column G opposite the first name
in each period that will return the number of names in the period.

Example:
Column A Column G
Student Name
SAM Formula returns 4
GEORGE
SLIM
FRANK

Student Name
GEORGE Formula returns 3
ALLEN
HENRY


Student Name
etc

Any ideas would be welcome! Thanks.