HELP! Sums from different Sheets!

taylorb1

New Member
Joined
May 4, 2009
Messages
2
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

Active Member
Joined
Oct 16, 2007
Messages
304
sounds like your column isn't wide enough to display the answer, try widening them
 

Forum statistics

Threads
1,082,478
Messages
5,365,780
Members
400,849
Latest member
candy2052

Some videos you may like

This Week's Hot Topics

Top