Results 1 to 1 of 1
  1. #1
    Join Date
    Mar 2008

    Unanswered: Formula to add from one tab to another

    Disregard post this should be in the excel forum - my applogies.

    I have a spreadsheet with tabs QTR 1, QTR 2, QTR 3, and QTR 3. I added another tab Year to Date. I placed a formula in the year to date tab as such ='QTR 1'!D4+'QTR 2'!D4+'QTR 3'!D4+'QTR 4'!D4.

    First it will not add up the number it give me a #value error. What I am looking to do is show a year to date roll up each quarter so in quarter 2, 3 and 4 there will be no values until that quarter. Do i need to add a zero in each of the cells in 2, 3 and 4 or do i have the formula incorrect

    Any help would be appreciated.
    Last edited by mtriolo; 02-03-12 at 16:42.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts