=SUM() Not working

[SteveFarr]

What would cause the sum function to only work in one direction?

I have a sheet that has 5 columns and 12 rows. The center column will not allow me to use sum horizontally. I can however, do it vertically.

This problem only occurs in one section of my worksheet, AND, it works fine in the first 4 rows, but not beyond that.

This worksheet has personal data in it, so I'd rather not post it if I can help it.

If there's any way someone could help, I'd sure appreciate it. I hope my description is enough to go on, but I understand if it's not...

[Norie]

Attach a sample workbook. Make sure there is just enough data to make it clear what is needed. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are demonstrated, mock them up manually if needed. Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

[SteveFarr]

Norie, I tried to delete all sensitive data and replace it with fictional data. Hopefully this will give you and any other moderators enough to work with...

[FDibbins]

you have some formulas in J (hidden) that are giving a #REF error, remove them

[SteveFarr]

Thank you, thank you. I knew it had to be something simple...