Need help with Excel formula for a termination report
 

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

Need help with Excel formula for a termination report
 

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:

<spaceDept Code
Dept Code<space
<spaceDept Code<space

--
Biff
Microsoft Excel MVP


"Courtney Rae" wrote in message
...
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