Sorry the one thats giving me trouble is the 7th row down from the top of the
range.

"M.A.Tyler" wrote:

TM-
This works well thanks for the help, Just a couple more things. The actual
data range has increased, so it's really A3:A646. Also how can I copy and
paste this array so if I would like the data stored in the 7th row but
counting down from the 4th row (from the top of the range) instead of the 3rd
and so on... I've gotten it to work down to starting from the 6th row, but
the 7th row down from the 7th row from the top is giving me a division error?

I hope the question makes sense. In other words if I start with your
original array formula in A1 and copy it down thru A5.

Can you help?

"Teethless mama" wrote:

Try this:

=AVERAGE(IF((MOD(ROW(A3:A640),7)=3)*(A3:A640<""), A3:A640))

ctrl+shift+enter, not just enter


"M.A.Tyler" wrote:

Need to average a column of numbers, except I only need to use every 7th row.
Like row 3,10,17......640. In addition not all of these cells are populated.
First is it possible to create a formula that would only use every 7th row?
Second how can I insure an accurate average by only counting populated cells?

Thanks,

M.A.Tyler.