What do you mean, it's not adding it up?

Do you get the wrong total, a zero or an error?

If it's the wrong total or zero perhaps some of your numbers are text.
Try to convert them to numeric or total them with

=SUMPRODUCT(--(A1:A10)


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=568834