totaling a column of results in excel

March 2, 2012 at 09:37:00
Specs: Windows 7
I am using excel 2002. I have prepared a spreadsheet that has formulas in each cell. I want to total the column of results but because the results are in quotes, a text string, it will not total. I have tried removing the quotes but it won't accept that and just shows the formula in the cell instead of the answer. I also tried using =d2+d3+d4 instead of the sum function... This does not work either.

See More: totaling a column of results in excel

Report •

March 2, 2012 at 09:51:49
Why are the results in quotes?

Since you didn't post the formulas that are returning the text strings, it's kind of hard for us to offer anything specific.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Report •
Related Solutions

Ask Question