Looks OK EXCEPT you seem to be array-entering them. SUMPRODUCT doesn't
require array-entry. You didn't say what's not working -- wrong answers?
#VALUE? same answers in each formula? what's happening?
Bob Umlas
Excel MVP

"Jackie K" <Jackie wrote in message
...
Shift Status 1st Shift 20
2 2 2nd Shift 3
1 2 3rd Shift 3
2 1 Unknown 0
2 1 Total Active 26

Above is the spreadsheet that I am working with. I am using a SUMPRODUCT
formula to tell me how many employees are on each shift. Below are the
formulas I am using to get the results listed after 1st Shift, 2nd Shift
and
3rd Shift. The formula works only if the data is not edited. If I change
any number in the shift column, the formulas do not seem to calculate the
value. Any ideas? Does this formula only work on unideted data?

{=SUMPRODUCT(--(L1:L5600="1"),--(M1:M5600=1))}

{=SUMPRODUCT(--(L1:L5600="2"),--(M1:M5600=1))}

{=SUMPRODUCT(--(L1:L5600="3"),--(M1:M5600=1))}

Any help would be appreciated.

Jackie K