MS Excel 2003 - How can I sum up all entries of the same items automatically, when the entries are widespread?

in one cell just type: "=sum" then highlight all those cell you want to sum up.Then press enter.