Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I'm trying to set up a budget where my last column shows what's left in my account in every cell from F6 to F30. I want the cell to only show it's value if another cell on the same row has a value.


If B6 is not empty, show the value of cell F6, leaving the rest of the cells in column F blank until they are summed up.The value in F6 is a formula from a different spreadsheet (=DATA!AH6).

I have tried =IF(B6="";"";"=DATA!AH6"), but it shows the text 'DATA!AH6', and not the value.

share|improve this question
Uhh @Tia, you might want to vote up and accept my answer if you feel it was helpful or it worked – YatharthROCK Aug 20 '12 at 8:58
Thank you. Can't get it to work in my sheet, but trying ; instead of , and with and without quotatinmarks. – Tia Aug 20 '12 at 9:54
Are you sure about using semicolons? I've only seen commas till now. – YatharthROCK Aug 20 '12 at 9:56
I'm using an european version of 2007, and not really able to find my way around it as I'm used to an english version of 2010. – Tia Aug 20 '12 at 10:10
Btw, how do I vote/accept? – Tia Aug 20 '12 at 10:10
up vote 0 down vote accepted

Add =DATA!AH6 w/o the quotes. Your formula should now look like


This worked for me:

   A   B   ...
1 100 200
2  1  =IF(A2="1",SUM(A1:B1),"")
share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

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