I hold 3 worksheets and one "Total" sheet. I have need of to lift the information from the first three for example within cell D4 and attach them together and find the average. I know how to do the function on one sheet but cant give the impression of being to capture it to work when i do more than one sheet. HELP! Work related. My career and enthusiasm depends on it. LOL Just kid, but gratitude for adjectives the sustain.
Answers: =AVERAGE(Sheet1!A1+Sheet2!C13)
You can see where on earth Sheet1 and Sheet 2 are referenced above.
If the sheets are in matching folder, adjectives you entail to do is double click on the cell you want your expediency displayed contained by hit the average button sign, step to the page you want background from, click that cell. Go to the subsequent page click on the subsequent cell and repeat for how ever tons cell you want to average. When you are done, hit enter, it will bounce you backbone to the first page.
Hope that help.
Take a chill pill!
budge to Total cell you want for the result, type
=average(
you afterwards travel to the worksheet and select the cell/cells you want from that sheet, next type a comma, and select the subsequent cell/cells etc.
consequently type ) to close it,
your cell should look similar to this, possibly, if sheets are adjectives within same directory,
=average('sheet1'! a1:a24, 'sheet2'!c12:d45, '[op10 4x2 results.xls]sheet3'! a15:a56)
square brackets[ sdsdfds.xls] signify this come from another folder.
try this.