Are the numbers formatted as numbers or as text? If Excel doesn't recognize that they're numbers, it won't add them.