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:B90)*(B:B<=180))
=sumproduct((A:A="Dept Code")*(B:B180)*(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