Sum with Criteria

hi guys,

I'm trying to get the total of each personnel with the criteria off D an N using this formula {=SUM(C8:BB8,$BC$7,$C$7:$BB$7)}, but it is not getting the exact total using the criteria "D" and "N".

Please help.