A mixed request

  • Thread starter Thread starter Con
  • Start date Start date
C

Con

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Vertical to horizontal repeat after 16 rows 3
Average data from different spreadsheets 1
Autofill cells in 1 column :code ?? 2
retrieve data into a spreadsheet from a copy of that spreadsheetwhich is saved as its own xls file 10
Move data from first 7 rows from one column A into multiple Columnsthen the next 7 rows 2
Over 29 args in a UDF with double parens 1
Before Double Click Procedure 1
Average problem 1

Back
Top