Excluding cells when adding sums together

Forum|Forum|5 years ago
April 30, 2020
2 replies
723 views

Hello,

I have a fillable PDF that totals the amount of several cells at the bottom (20 total). In some cases it is a dollar amount (which I want it to sum up) and in other cases it is text or percentages that I want it to exclude. Is this possible to exclude them and how do I do it?

Thanks

This topic has been closed for replies.

Thom Parker

Community Expert

If the user types in a % or $, then the number values can be differenciated, but otherwise a number is a number.

Thom Parker - Software Developer at PDFScriptingUse the Acrobat JavaScript Reference early and often

try67

Community Expert

Just don't include them in the list of fields you're adding up... Or do you mean that in some cases you do want to include them in the calculation, and in others you don't? If that's the case, what is the condition to include (or exclude) them?

L

leewarn@hotmail.comAuthor

Participant

It is a spreadsheet that is used with multiple people so I will not know when certain people will need to add a percentage or a dollar amount. I wanted it to assume that if the cell was a dollar amount to add it to the total and if it was a percentage to exclude it.

try67

Community Expert

You can't format a field to be both. So does the field have no Format setting at all, and people just enter to it what they want?

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.

Scanning file for viruses.

This file cannot be downloaded