Sum If 2xConditions

[AshaKai]

I buit a sheet to help a friend manage a small ebay business and his personal finaces together. I used a lot of sum if with 2 conditions, which has resulted it my "bank" sheet freezing when inputing data.
Could someone advise me if there is a better formula to use that would not cause slowdown, or how to make the DATA sheet only update once all new data has been enterd.
I built the woookbook in 2007 as a xlsx fill, i have converted it to a xls file and added both to the zip, the freezing issue does to seem to happen it the xls version but i am unsure how much data has been lost in the conversion and if the xls sheets will work correcly once full.
Thank you for anyhelp on this matter as i am quite new to excel and just taught my self from google.

Thanks Again

[Carim]

Hi,

If you are referring to your formula in sheet bank column G, there is no reason for this formula to "slow down" your calculations ...
As far as the data sheet is concerned, you can always set Tools Options Calculation to Manual and hit F9 for updates ...

[AshaKai]

Do you think there is a way to create the data sheet that doen't cause slow down, or should i just use stick with the f9 option?

Thanks