Need help with Excel formula for a termination report

[Courtney Rae]

I am trying to create a formula for a termination report I am
creating. A=Department Codes and B=Number of days worked

This is what i have so far in 4 different Cells:

=sumproduct((A:A="Dept Code")*(B:B<=90))
=sumproduct((A:A="Dept Code")*(B:B>90)*(B:B<=180))
=sumproduct((A:A="Dept Code")*(B:B>180)*(B:B<=730))
=sumproduct((A:A="Dept Code")*(B:B<730))


When I enter this formula it always states 0. If I take out the
(A:A="Dept Code"); it does figure the days worked, but it is not
dividing it out by deparments.

Any help would be appericated!!!

Thanks,
Courtney

 

[T. Valko]

If I take out the (A:A="Dept Code");

it does figure the days worked

Then that means column A does not *exactly* match Dept Code (case not a
factor).

In column A you may have leading/trailing spaces (or other unseen
characters) like this:

<space>Dept Code
Dept Code<space>
<space>Dept Code<space>