Dear All, your help is appresiciated in advance.

I have a micro in sheet A which when activated copies 3 numbers from
sheet A and inserts them into sheet B in A2:A4.
Meanwhile I have an IF function in sheet A which checks the average of
numbers A2:A16 in sheetB. Now my question is, when I insert 3 numbers
in sheet B, the IF function in sheet A calcualtes the average of A5:A19
instead of the required average of A2:A16, i.e., I want to the average
of A2:A16 always even if I insert any numbers in column A.
Thank you.

Maybe something like:

=AVERAGE(INDIRECT('sheetb'!"a2:a16"))

I'm not sure how the IF portion fits in.

Con wrote:

Dear All, your help is appresiciated in advance.

I have a micro in sheet A which when activated copies 3 numbers from
sheet A and inserts them into sheet B in A2:A4.
Meanwhile I have an IF function in sheet A which checks the average of
numbers A2:A16 in sheetB. Now my question is, when I insert 3 numbers
in sheet B, the IF function in sheet A calcualtes the average of A5:A19
instead of the required average of A2:A16, i.e., I want to the average
of A2:A16 always even if I insert any numbers in column A.
Thank you.

--

Dave Peterson

Thank you Dave. It worked.

Con