• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

continious adding.

A

aratrika

New Member
I have an worksheet (say worksheet A) for calculation of TDS of the employees. I used to process salary in another worksheet(say worksheet B)in separate sheets for every month i.e sheet 1 for Apr , sheet 2 for May and like that. The same row is maintained every month for individual and I want all months salary (Apr - Mar)for one individual to be added in a particular cell of the worksheet A. Suppose Mr. X salary has been processed every month in worksheet B and his total of salary from Apr - March to be added in a particular cell of worksheet A. I want to avoid using the formula like Sheet1+ sheet2 and on and on since it is very long. I look forward if some body can suggest a better formula.

Thanks Regards

aratrika
 
If the Names are in the same rows and Day the same columns you can simply do a sum using sheets names in the ranges

Like:

=SUM(Sheet2:Sheet10!E5)

or

=SUM(Sheet2:Sheet10!E5:E10)

etc
 
And just to add on to this if you create 2 empty sheets and name them say start and end and use these as your sheet references then your formula will be dynamic so long as all other sheets and new sheets added are between these 2 empty "marker" sheets.

John
 
You must log in or register to reply here.
Back
Top