Calculating Average

  • Thread starter Thread starter ub
  • Start date Start date
U

ub

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.
 
Back
Top