0

I am using the formula below. It will only update when I go into the cell and push "enter" to leave the cell.

I think it is due to the iferror function. It is calculating correcting but I have to hit return.

=sum(iferror(January!B4,0), iferror(February!B4,0), iferror(March!B4,0), iferror(April!B4,0), iferror(May!B4,0), iferror(June!B4,0), iferror(July!B4,0), iferror(August!B4,0), iferror(September!B4,0), iferror(October!B4,0), iferror(November!B4,0), iferror(December!B4,0))
Improve this question
6
  • share a copy of your sheet pls
    – user0
    Commented Jul 28, 2019 at 19:50
  • I can't share the specific one. I created a test sheet but the issue is not showing up. weird. docs.google.com/spreadsheets/d/…
    – Berek Bryan
    Commented Jul 28, 2019 at 21:24
  • 2
    i just removed the formula then added it back in and now it seems to be working.
    – Berek Bryan
    Commented Jul 28, 2019 at 21:26
  • could have been som glitch, ...glad it's resolved
    – user0
    Commented Jul 28, 2019 at 21:36
  • 1
    thank you for checking in.
    – Berek Bryan
    Commented Jul 28, 2019 at 21:50

1 Answer 1

Reset to default
1

  • no need for zeros:

    =SUM(IFERROR(January!B4), 
     IFERROR(February!B4), 
     IFERROR(March!B4), 
     IFERROR(April!B4), 
     IFERROR(May!B4),
     IFERROR(June!B4),
     IFERROR(July!B4), 
     IFERROR(August!B4),
     IFERROR(September!B4),
     IFERROR(October!B4),
     IFERROR(November!B4),
     IFERROR(December!B4))

Improve this answer

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.