The AVERAGE Function

[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!

 

[Chip Pearson]

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?

 

[dvt]

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?

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

 

[Ron Rosenfeld]

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!

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