View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
JLatham JLatham is offline
external usenet poster
 
Posts: 2,203
Default How do i get Excel find a sum of #s om different pages/books?

Just to add to what Bob Phillips provided:
A sheet named January and a sheet named December need to exist, and all
sheets with the other month names need to be positioned between them in the
workbook.

As he said, even tho we are currently only in September, then October,
November and December's salaries are presumably zero, so they're non-players,
but will update as those months are completed.

"Birthe" wrote:

I am using Excel to work out wages, and i have my excel set up so that i can
see all months from January to now in different "sheets". What i would like
it to be able to do is, that i would like to be able to put an extra section
in, so that on each pay check, people will be able to see how much they have
earned from the start of the year, till today, how do i make it work that out
automatically without having to tell it to work out the sum of I22 January,
february, march, april, may, june, july, august, and september, and then next
month having to tell it all tha again plus one month.

If you dont understand let me know and i can try to send u a copy of what im
talking about and you can play around with it a little...