Help with formulas

Report · May 18, 2016

I have a fairly simple form that I need to do some simple calculations with.

Cell A is number of items

Cell B is price per item

Cell C is total cost

Easy peasy and I can do that one no problem.

The problem is Cell D: Grand Total or adding up all of the Cell C's.

Then at the bottom of the column where Cell C is I need to total the column but since that column contains a formula its not seeing the number and therefore not giving me a grand total in Cell D.

I hope this makes sense. Can someone help me figure out how to fix this?

Thanks much,Matthew

Report · May 18, 2016

The problem is not related to the fact that the field in column C contain formulas. I suspect the field calculation order is incorrect. Fortunately, this is an easy fix and the exact steps you take to correct it depends on which version of Acrobat you're using. You'll find more info in this previous thread: Acrobat fails to perform sum calculation?