help please javascript - sumif (X:Y,>"0")*1000000 equivalent

4 replies
660 views
Translate

Hello everyone,

I am hoping you can help me solve a problem.

I am new to pdf forms and javascript.

I have set up a basic form that functions as a calculator.

The form was originally in excel and I was able to use the formula SUMIF(X:Y,>"0")*1000000

All the formula does is checks for positive values in a range and then sums only the positive values eventually multiplying them by $1 000,000.

I am trying to have the result display in a form text box (light blue box with the $2,119,244,485.00 number)

This topic is closed to new replies. Start a new post to keep the conversation going.

try67

Community Expert

What are the names of the fields you want to use for this calculation?

Translate

martins77869509Author

Participating Frequently

Hi there thank you for your reply,

the field names are;

The field where I want the output is named "Estimated Funding Requirement Over and Above" that's the light blue cell in the form 5th one in the first area.

in the formula SUMIF(X:Y>"0")*1000000

X:Y range is named: A39, B39, C39, D39, E39, F39, G39, H39, I39, J39, K39, L39, M39, N39, O39

0 is named: Zero

1000000 is named: One Million

thank you

Translate

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.