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