Hi,
I have a set of columns (Project, Employee, Week 1, Week 2 .. etc.) with values in them for about 3000 records. Since I didn't want any calculations to be done to the values in the Date columns, I added them to the Row labels instead (Tabular Form). Now the problem is that I need the total sum of the values for these Dates Columns which is not possible since the columns are being read as text fields. Is there any other alternative that I can use instead?
I'd like to have a Total sum (Week columns only) for each records at the end.
Btw I'm using Excel 2013.
Any help would be much appreciated!
I have a set of columns (Project, Employee, Week 1, Week 2 .. etc.) with values in them for about 3000 records. Since I didn't want any calculations to be done to the values in the Date columns, I added them to the Row labels instead (Tabular Form). Now the problem is that I need the total sum of the values for these Dates Columns which is not possible since the columns are being read as text fields. Is there any other alternative that I can use instead?
I'd like to have a Total sum (Week columns only) for each records at the end.
Btw I'm using Excel 2013.
Any help would be much appreciated!
