Transfer average data

[jimpatel1993]

Hi,

Thanks for looking at my post.
Really appreciate if i get help on this post please

I have two sheets named as source and destination. What i am after is i wanted to add even rows together from row 2 and divide by number of times data available and transfer to destination please. Same thing for odd rows.

i.e I have data from row 2 till row 15, that is i have 7 blocks of data.
so it will be 25+21+5+5+2+1+5 = 64 divided by 7 will be 9.2. I wanted to transfer that 9.15 to destination please.
Same thing for 5+3+1+55+5+2+2 = 73 divided by 7 will be 10.4

Once data is added more i would like to take an average automatically please

Really appreciate if I get any help on this please.

[HansV]

In C2 on the destination sheet:

=AVERAGE(IF((source!$C$2:$C$1000<>"")*(MOD(ROW(source!$C$2:$C$1000),2)=MOD(ROW(),2)),source!$C$2:$C$1000))

Confirm with Ctrl+Shift+Enter, then fill down.

[jimpatel1993]

Fantastic Hans

Thanks a lot again