HELP! Sums from different Sheets!

[taylorb1]

I am trying to create a spreadsheet for monthly expenses where the fixed expenses are on sheet 1 and the actual table is on sheet 2...

Fixed expenses in sheet 2 are denoted by =Sheet1!$B$3 ect, referring to sheet 1. I then tried to sum up all of the months expenses I get the correct answer on the "formula result help bar", but when I push OK or hit enter ###### appears in the cell time after time.

It seems very strange, when I sum up any two of the references to sheet 1 I can get a number sum, but when I do all 3 I get ######

Also, when I add the variables expenses as well I can get a result only when including two of the references, not all three!

Can anyone help me please!?

Thank you

 

[Tony Miall]

sounds like your column isn't wide enough to display the answer, try widening them

 

[taylorb1]

haha well I feel like an idiot! :P Thank you so much!