Sun Tzu
02-06-2004, 05:13 PM
Real quick like.
I'm trying to figure out how to find an average $$$ amount out of about 200 seperate figures. The thing is they are not all in a row. They are all in seperate areas in the spreadsheet. Like say an average of the numbers in G10:G69 AND G113:G210 AND etc... How would I go about doing this? I have tried a couple different ways and I just keep getting error messages. Any and all help is greatly appreciated.
I'm trying to figure out how to find an average $$$ amount out of about 200 seperate figures. The thing is they are not all in a row. They are all in seperate areas in the spreadsheet. Like say an average of the numbers in G10:G69 AND G113:G210 AND etc... How would I go about doing this? I have tried a couple different ways and I just keep getting error messages. Any and all help is greatly appreciated.