diamant-pige Posted September 17, 2006 Share Posted September 17, 2006 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 Link to comment Share on other sites More sharing options...
jaclaz Posted September 17, 2006 Share Posted September 17, 2006 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!I11On Mar=Jan!I11+Feb!I11etc.jaclaz Link to comment Share on other sites More sharing options...
hazard_abio Posted September 18, 2006 Share Posted September 18, 2006 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) Link to comment Share on other sites More sharing options...
Anne Troy Posted September 21, 2006 Share Posted September 21, 2006 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 Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now