I have seven columns on my spread sheet. the first six are calculating. the seventh and the latest gives me a 0 when I add the numbers in the column
Do you mean you got 0 when you add the first 6 columns? Or the first 6 columns calculates the information/data accurately?
Either way, you might need to check that the cell are not formatted as text. Or you can share a sample data to investigate the issue.