average problems

[kacz7895]

This is the cover sheet or tab

AVERAGE STARTING WEIGHT
AVERAGE WEIGHT LOST
AVERAGE % WEIGHT LOSE

These are the colomns i am trying to pull the data from. each person has ther own row


STARTING WIEGHT TOTAL LOST % LOST



I am trying to get the average for the above but the average formula is only letting me do it for it for one sheet at a time and i have 26 sheets or tabs. any help would be awsome

[darkyam]

Perhaps a sample workbook would help. I'm not picturing how those three bits of data, with every person on their own line, needs 26 tabs. Are the lengths of the tables different on the various tabs?

[kacz7895]

i am on a government computer so i cant post the spreadsheet
the first sheet or tab at the bottom of the workbook looks like this

AVERAGE STARTING WEIGHT
AVERAGE WEIGHT LOST
AVERAGE % WEIGHT LOSE
all other tabs or sheets look like this

STARTING WIEGHT TOTAL LOST % LOST
EXAMPLE
If i were to enter the persons name of jane doe. she would go under the d tab or sheet
if i were to enter the persons name of jane foster it would go under the f tab or sheet

i hope this helps

[darkyam]

Provided there aren't totals at the bottom of these tabs, something like this would work in Tab 27, B2: =AVERAGE(Sheet1:Sheet26!B2:B4), where B4 refers to the last cell on the tab with the most data. Weight lost could be modified to go off of column C. As a caveat, note that there would be a difference between modifying the above for % Lost and simply dividing B3 by B2. It will likely be small, but averaging the averages will assign them all the same weighting (no pun intended) whereas taking average weight lost divided by average starting weight will give more weight to percentages lost for higher starting weights.

[kacz7895]

=AVERAGE(Sheet1:Sheet26!B2:B4)
i will try to use this. my sheets are labled a-z should i change this formula to this
=AVERAGE(Sheeta:Sheetz!B2:B4)

[darkyam]

If they are not literally "Sheeta", "Sheetb", and so on, but "a", "b", etc., then simply =Average(a:z!B2:B4)

[kacz7895]

I havew tried that and did some research i fould this page and from my under standing you can only have 255 arguments and i need over 700 to make it work

http://spreadsheets.about.com/od/exc...07-average.htm

thank you for the help

[darkyam]

By this, I assume you mean you have over 700 rows of total data. Is that correct?

Anyway, an argument can be a range of cells, so 255 arguments means you can specify 255 distinct ranges if you want. At best, this would be only 26. What results are you getting when you try it?

[kacz7895]

i am getting htis error # N/A

[darkyam]

Don't understand why. Is your numeric data stored as text perhaps? Perhaps this workbook will help.

[kacz7895]

dont know if i can do this on this forum but send me an im and ill send you the worksheet to your email