How to sum a column in excel 2003
The number in the cell is the hours on the job which I want to assign to one of 3 codes (say A,B,C) but I want to find a way to sub total each activity A,B,C into 3 cells at the end of each col (date.
![how to sum a column in excel 2003 how to sum a column in excel 2003](https://cdn.ablebits.com/_img-blog/excel-compare-two-columns/compare-2-columns-mark-duplicates.png)
![how to sum a column in excel 2003 how to sum a column in excel 2003](https://cdn.ablebits.com/_img-blog/excel-sum/excel-conditional-sum-multiple-criteria.png)
In our example we chose the cell range =SUM(C3:C8). Click into the desired cell you wish to add contents and type =SUM( and then the cell range you wish to add.
![how to sum a column in excel 2003 how to sum a column in excel 2003](https://i.ytimg.com/vi/K0_kYTwpBFY/maxresdefault.jpg)
#How to sum a column in excel 2003 how to
In other words, how to take the value of a cell located in one worksheet and add it to the value of another cell located in another worksheet to come up with the total of the respective cells. This document explains how to calculate the sum or total when working with cell data located in multiple worksheets.