SRL Archive - Help and Support

I need help writing script(s) in google spreadsheet.

https://spreadsheets0.google.com/spreadsheet/ccc?authkey=CIT8j-YI&hl=en_US&key=tyTx9oDKaOoYZHl-XDFo5Lw&hl=en_US&authkey=CIT8j-YI#gid=0
That's my current project… Now I would like to calculate average of each item. However there is hundreds of rows and I might add some later so I wouldn't like to use formula like =B2+B3+B4….+B207. Instead I would like to add a macro that loops through them all…

If someone can help me I wouldn't mind paying some rsgp for it. Maybe 20M?

add me on msn, Ill see what I can do, seems kinda easy.

Thanks KingKong for the help :)

From: antti mies
=B2+B3+B4….+B207. Instead I would like to add a macro that loops through them all…

=sum(B2:B207) or =cum in Excel iirc, probably something the same in G Spreadsheet.

From: Markus
=sum(B2:B207) or =cum in Excel iirc, probably something the same in G Spreadsheet.

Yea we did it in a similar way but we used Average(B2:B) instead of sum.

Just call it Excel not google spreadsheet! :D AFAIK Excel was the first to make that kinda stuff and google spreadsheet is just a 'clone' of it for people who would like to have it free/work online! :]

Excel -> the program you have on your comp
Google Spreadsheets -> your [excel] spreadsheets up in the cloud for you to access/modify anywhere

Just feel like it should be called 'Excel Help' or whatever, not google spreadsheet help! Just personal preference :D

Except that Google Spreadsheet is actually modelled after open office :)

And I'm sure open office was modeled after excel. I think excel came first and then open office came as a clone/free alternative.

From: YoHoJo
And I'm sure open office was modeled after excel. I think excel came first and then open office came as a clone/free alternative.

From: http://en.wikipedia.org/wiki/StarOffice#History
The German company StarDivision in Lüneburg (founded by 16-year-old Marco Börries in 1984) wrote the original components of StarOffice. StarDivision developed the first version of StarWriter for the Zilog Z80 home-computer system, the Amstrad CPC (marketed by Schneider in Germany) under CP/M, and later for the Commodore 64 under Microsoft BASIC, which was later ported to the 8086-based Amstrad PC-1512, running under MS-DOS 3.2. Later, the integration of the other individual programs followed as the development progressed to an Office Suite for DOS, IBM'S OS/2 Warp, and for the Microsoft Windows operating-system. From this time onwards StarDivision marketed its suite under the name "StarOffice."

Then..

From: http://en.wikipedia.org/wiki/Microsoft_Office
1990; 21 years ago

I'm not really sure which came first.. they seem to have developed in parallel!

I'm not exactly sure what you're trying to do, but =average(xxxxx) is probably what you want. There are all kinds of little shortcuts in excel as well. You could do an =if( or maybe =iferror( command if you want to add the whole column/row to an equation and leave the blank ones blank.

From: Brain
I'm not exactly sure what you're trying to do, but =average(xxxxx) is probably what you want. There are all kinds of little shortcuts in excel as well. You could do an =if( or maybe =iferror( command if you want to add the whole column/row to an equation and leave the blank ones blank.

Thanks. As I said earlier I used =average() :) First I thought I had to make my own script or something that loops through all the wanted cells.