Share via

Combining two schedules

Anonymous
2012-01-03T16:29:21+00:00

I have two budgets, each on a seperate schedule. How do I combine the two to get totals for the year?

Thanks for your help

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

Anonymous
2012-01-03T17:09:18+00:00

Hi, not sure what you need , do you want to summarize sheet1 and sheet2 for example if yes you can have a formula like

=sheet1!A1+sheet2!A1

an example will definetely help

Was this answer helpful?

0 comments

3 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2012-01-03T19:05:50+00:00

    Thanks so much! Will work on it!

    Was this answer helpful?

    0 comments
  2. Anonymous
    2012-01-03T18:56:46+00:00

    Hi Barbara, another way you have is to have a consolidation sheet for example in another sheet you have the month from Jan to Dec and then pull the information from Jan to Jun from sheet 1 using

    =sheet1!A1

    and then pull Jul to Dec from sheet2 using

    =sheet2!G1

    then you will have a total for ytd

    Was this answer helpful?

    0 comments
  3. Anonymous
    2012-01-03T17:44:10+00:00

    Thanks.

    I have Jan to June in sheet 1with totals of each catagory.

    July to december in sheet 2.

    Want to combine the totals to reflect year's spending....ouch!

    Thanks....will try the formula and see how it comes out.

    B. Jorgensen

    Was this answer helpful?

    0 comments