I have 3 worksheets and one "Total" sheet. I need to take the data from the first three for example in cell D4 and add them together and find the average. I know how to do the function on one sheet but cant seem to get it to work when i do more than one sheet. HELP! Work related. My job and life depends on it. LOL Just kidding, but thanks for all the help.
2007-10-30 02:00:47 · 4 answers · asked by Bean 1 in Computers & Internet ➔ Software
=AVERAGE('Bill 1'!E2,'Bill 2'!E2,'Bill 3'!E2) I have this formula. But my cells are in time 660:00 six hundred and sixty mintues and no seconds. It wont average that. I get #DIV/0 error. I checked the formating and put it as general and custom mm:ss. I don't know if it the formating or what but i get that error.
2007-10-30 05:59:39 · update #1
=AVERAGE(Sheet1!A1+Sheet2!C13)
You can see where Sheet1 and Sheet 2 are referenced above.
2007-10-30 02:07:16 · answer #1 · answered by john4938 3 · 1⤊ 0⤋
If the sheets are in the same file, all you need to do is double click on the cell you want your value displayed in hit the average button sign, go to the page you want data from, click that cell. Go to the next page click on the next cell and repeat for how ever many cells you want to average. When you are done, hit enter, it will bounce you back to the first page.
Hope that helps.
2007-10-30 09:09:11 · answer #2 · answered by The Major 4 · 0⤊ 0⤋
Take a chill pill!!!
go to Total cell you want for the result, type
=average(
you then go to the worksheet and select the cell/cells you want from that sheet, then type a comma, and select the next cell/cells etc.
then type ) to close it,
your cell should look like this, perhaps, if sheets are all in same file,
=average('sheet1'! a1:a24, 'sheet2'!c12:d45, '[op10 4x2 results.xls]sheet3'! a15:a56)
square brackets[ sdsdfds.xls] signify this came from another file.
try this.
2007-10-30 09:19:13 · answer #3 · answered by clinky 3 · 0⤊ 0⤋
Find your answer, free at:
2007-10-30 09:08:02 · answer #4 · answered by ELfaGeek 7 · 0⤊ 1⤋