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:

Please Login or Register  to view this content.

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:

Please Login or Register  to view this content.

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

Hi Elite311,

Welcome to the forum!

You'll need to correct your named range "amount" to:

=Budget!$H$8:$H$4000

then use this formula in cell Totals!C6:

Please Login or Register  to view this content.

Autofill it to C6:D19

Cheers,

Did you also get the "$" sign?

Here's the copy I was playing with:

Yup. In the defined name "amount" you have the formula:

=Budget!$H$8:$H4000

but you're missing the "$" sign in front of the 4000.

Try it like this:

=Budget!$H$8:$H$4000

Cheers,

You're working too hard; take a break!