I am trying to use excel to work out saläries, and i have it set up so that i have worksheets for january through december, i need it to be set up so that for each month that i put numbers in, i need it to work out how much has been earned up to that point...Meaning if we are in september, then i have an area that automatically works out how much has been earned from january and til today...and then when i get to october it adds that to the total...But i'd like a formula that does that without me having to work it out each time.

Any advice??

I was told to use eg. =SUM(Jan!I11:Dec!I11)

But it doesnt seem to work...am i doing something wrong?

-->moved to Excel Forum

-N1K

I don't think that you can do that, because you cannot sum "intermediate" sheets.

But why dont you make it simple:

On Feb

=Jan!I11

On Mar

=Jan!I11+Feb!I11

etc.

jaclaz

well as long as all of the cells stay in the same spot you can still use the sum function, but it looks a little different (kinda likewhat jaclaz said.)

=SUM(Jan!I11,Feb!I11, Mar!I11, Apr!I11, May!I11, Jun!I11, Jul!I11, Aug!I11, Sep!I11, Oct!I11, Nov!I11, Dec!I11)

LOL. Glad I'm not using those long formulas. You *can* sum intermediate sheets.

Try this:

http://www.officearticles.com/excel/sum_th..._worksheets.htm