need help with if statement?

[doublet33]

Hi,

i am currently using this IF statement:

=SUM(IF('Sales Input'!B5="Jul",'Sales Input'!$C$43,0))

what happens is

i select a month from a dropdown list i created in sheet "sales input"
i then add data into selected cells which are then updated into a different sheet called "cash flow" into cells depending on which month i selected.

However doing it this way means for all the other months i am not changing at the time, are left with £0.00, is there anyway to change the IF statement so it leaves the cell with the current figures? i dont want it to be blank but id like the figures to stay when selecting a different month from the drop down list in the sheet "sales input"

Using mac 2011 version

Thanks for your help

Tim

 

[doublet33]

i got told on another forum to do this


Have another cell hold the default outcome, and make the false statement select that cell.

how would i create this cell that holds only the default outcome tho?