The AVERAGE Function

  • Thread starter Thread starter NY_assistant
  • Start date Start date
N

NY_assistant

Hello-

I am trying to find the 'average percent' for a
spreadsheet in which the percent number is every 3 columns.
Average (A1:A20) wont work because it will include data
that shouldnt be averaged. for some reason =Average(A1,
A4, A7..etc) is not working. Any ideas?

Thanks!
 
Specifically what do you mean when you say that the AVERAGE(A1,A4,A7)
function "is not working"? Do it give an error result? An incorrect number?
 
NY_assistant said:
Hello-

I am trying to find the 'average percent' for a
spreadsheet in which the percent number is every 3 columns.
Average (A1:A20) wont work because it will include data
that shouldnt be averaged. for some reason =Average(A1,
A4, A7..etc) is not working. Any ideas?
Click to expand...

Chip is right, you haven't given enough details to give an answer that is
definitely correct. But I'm going to make a guess anyway. How about this:
=SUM(A1:A20)/COUNT(A1:A20)

Dave
dvt at psu dot edu
 
Hello-

I am trying to find the 'average percent' for a
spreadsheet in which the percent number is every 3 columns.
Average (A1:A20) wont work because it will include data
that shouldnt be averaged. for some reason =Average(A1,
A4, A7..etc) is not working. Any ideas?

Thanks!
Click to expand...

Your range is only in one column. Perhaps you mean the percent is in every
third *row*??

What do you mean by: "=Average(A1,A4, A7..etc) is not working" ???


--ron
 
Back
Top