There is no direct way.But there is an indirect way if you are using
Microsoft Excel 2003

CLIK CTRL+F
CLIK OPTIONS
GO TO THE FORMAT BOX AND SELECT THE CELL HAVING YOUR FORMAT AND CLIK
FIND ALL
When the results are displayed,Select ALL THE RESULTS.
The sum would be highlighted in the STATUS BAR

For more join
http://groups.google.co.in/group/Answers-for-everything