Ok, here's what I still don't understand. When I select a range of cells, it totals them up twice (the individual numbers plus the totals). Are you telling me that manually clicking on hundreds of individual cells (I have several hundred different items) to total them up is the only way to do this?