Column Not Calculating

F

ftpsteve

I have a financial spreadsheet that has a ton of columns.

In the total colums, I can calculate the row. But when I try to
calculate that column, I get 0.00.

If I try to calculate the column somewhere else, I still get zeros. It
is acting like there are no values in the cells in the column.

Any ideas?
 
A

Arvi Laanemets

Hi

Check the cell format in column - it's probably Text. When this is the case,
then after reformatting the column, you have to reenter all values/formulas.


Arvi Laanemets
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Remove Identical words 0
Excel formula help for calculating freight. 2
Cumulative time calculation in Excel 2003 3
Need Help with a VBA subroutine 0
Calculate Total Hours when Overlapping Occurs 0
Help with lots of formulas 3
Help needed: Minimum value based upon either/or criteria 3
Sum of values in column A based on 0/1 of column B 2

Top