Hi I have date arranges in cells as

Cell# Column A Column B
1 Name1 10
2 20
3 SUM( 30)
4 Name 2 20
5 50
6 SUM(70)
7 <Blank
8 Name 3 20
9 SUM(20)

I have name of employee in Column A and there total marks in Column B in
Cell - SUM
What I want to do is to calculate the average for only those employees whose
name is enetered in Column, the average is calculated for the column B of
cells SUM.

Please advise

How about something like:

=SUMIF(A1:A9,"""",B1:B9) / COUNTIF(A1:A9,"""")

"ub" wrote:

Hi I have date arranges in cells as

Cell# Column A Column B
1 Name1 10
2 20
3 SUM( 30)
4 Name 2 20
5 50
6 SUM(70)
7 <Blank
8 Name 3 20
9 SUM(20)

I have name of employee in Column A and there total marks in Column B in
Cell - SUM
What I want to do is to calculate the average for only those employees whose
name is enetered in Column, the average is calculated for the column B of
cells SUM.

Please advise

Not sure I interpreted your needs correctly. Is the result you're expecting
16.667 or is it 40?

If you're looking for a result of 40, you're going to be better off putting
an indicator in column A like "Total" or other phrase that a formula can key
off of to do the counting of entries and identifying what to add and divide
by.

"ub" wrote:

Hi I have date arranges in cells as

Cell# Column A Column B
1 Name1 10
2 20
3 SUM( 30)
4 Name 2 20
5 50
6 SUM(70)
7 <Blank
8 Name 3 20
9 SUM(20)

I have name of employee in Column A and there total marks in Column B in
Cell - SUM
What I want to do is to calculate the average for only those employees whose
name is enetered in Column, the average is calculated for the column B of
cells SUM.

Please advise