excel / oo question

elexes

right ive a spreadsheet doc with about 200 sheets in it

basicly i want to try and make my job of counting each sheet quicker

is there any way i can get it multiply column a by column c of each sheet and add the totals

or if i i go through each sheet manually auto sum them so that cell e5 has the totals is there any way i can get it to auto sum sheet 1-200 e5 ?

hope i havent confused anyone with that .

Eoinsku

I'm no programming whizz, but couldn't you write some macro to do it?

Capt'n Midnight

In a sheet cell you can show a reference to a cell in another sheet.
1.Open a new, empty spreadsheet.
2.By way of example, enter the following formula in cell A1 of Sheet1:
=Sheet2.A1

this works =sheet1.e5+sheet2.e5 so plan B is to have a long expression
Try =sum(sheet1.e5:sheet200.e5)

elexes

cool will give it a go

alas no it didnt work looks like copy and paist

watty

TWO hundred sheets???
Someone needs a Database.

the_syco

=sum(Sheet1:Sheet3!C20)

The above is Sheet1 to Sheet 3, using cell C20. Change it to suit yourself.