Most likely the weights are seen as text by Excel, go to source code and use

=ISTEXT(A2)

replace A2 with the first cell in weight column, copy down, if you get TRUE
the values are text, one remedy would be to copy an empty cell, select all
the weights and do editpaste special and select add. If that does not work
you must have hidden characters in your range.

--

Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com
"It is a good thing to follow the first law of holes;
if you are in one stop digging." Lord Healey


"Angela Giuliano" <Angela wrote in
message ...
I have a large data set which I am trying to summarize. Basically I am
trying to sum the weight of fish caught by site. It shows the counts
correctly but everytime I try to switch the calculation to sums, it
displays
0 for all of the cells which I know not to be correct. Does anyone know
what
is going on? I have been trying to figure it out all day.

If it helps, I am using Excel 2002.