Greetings all,

I'm having a problem with my manual calc taking 20-30 seconds to finish.
Here's the scenario...

I'm basically creating a series of Trial Balances (accounting schedule) for our various company departments all in one workbook. The workbook includes two source data files..one for financial actuals and one for financial budget, and a trial balance worksheet for each department...when finished it should be about 30 TB's for 30 departments. I'm basically using Sumif statements to bring in the data that matches an account/dept/month criteria for each of these worksheets. The file itself is not that big (7,727 kb) so that shouldn't be a problem. Also, I've gone ahead and copy/valued a number of the sumif's thinking that might help but didnt really do much good.

Anyway, first time posting here so looking forward to any helpful suggestions.

Thanks!