IF & SUMIF Formula problem

I am trying to create a sheet to track credits that have been given out. Basicaly what I have is 2 sheets 1 the employees update and 1 that gives me totals based on markets and department. I have it working for the most part but the problem I have is when I use the folowing formula:

=IF(Budget!I8=market1,SUMIF(dept,service,amount))

It works perferctly but that only adds the one row with I8 cell and nothing else on the employee sheet. If i change it to:

=IF(market=market1,SUMIF(dept,service,amount))

I get a #VALUE error. I want to get info from the entire column not just one cell. Can anyone help me with this?

I attached a copy of my file aswell. I'm also using excel 2003

Thanks in advance