Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

mannyd3lr3y
mannyd3lr3y
Offline

Badges

Badges
4

Accepted Solutions

Accepted Solutions
0

Likes Received

Likes Received
0

Posts & Comments

Posts & Comments
10

Discussions

Discussions
0

Questions

Questions
1

Ideas

Ideas
0

Blog Posts

Blog Posts
0
Top badges earned by mannyd3lr3y
Customize the badges you want to showcase on your profile
Re: SUMIFS formula - Adobe LiveCycle 02-03-2011
THANK YOU SOOOOO MUCH, BRUCE!!!

Views

395

Likes

0

Replies

0
Re: SUMIFS formula - Adobe LiveCycle 02-03-2011
Was I supposed to rename each row? If so, do I leave this part "select all row subforms (e.g. Row1, Row2, ...)" as is or should I change it to whatever the cell name is?

Views

394

Likes

0

Replies

0
Re: SUMIFS formula - Adobe LiveCycle 25-02-2011
https://acrobat.com/#d=xsZJcrrFXHfNE4fDF6PviAhere you go... I published it.Thank you!

Views

391

Likes

0

Replies

0
Re: SUMIFS formula - Adobe LiveCycle 25-02-2011
https://acrobat.com/#d=xsZJcrrFXHfNE4fDF6PviAThanks

Views

392

Likes

0

Replies

0
Re: SUMIFS formula - Adobe LiveCycle 25-02-2011
Hi Bruce,I am so sorry for being such a pain but let me show you how my table looks like and maybe it will help me explain what I am trying to accomplish here.Pre-paidAmountAirBusRailRent-A-CarParkingGasShuttleTaxiPersonal CarRegistration FeeHotelInternet FeeMealsTollsPhone CallsPer DiemMiscTotal Expenses IncurredPre-paid ExpensesAmount due to ClaimantThe "Pre-paid" column is a drop-down with options of Yes, No, and N/A in which I renamed each cell to "PrePaid". What I would like to do is to sum...

Views

392

Likes

0

Replies

0
Re: Formula that checks drop down list and then sums - Adobe LiveCycle 24-02-2011
Is it possible to have a pre-made table already? I tried the code you provided however in my case, I do not have the "add row" button. I already have a table with 20 rows with an amount column and a dropdown column.

Views

116

Likes

0

Replies

0
Re: SUMIFS formula - Adobe LiveCycle 24-02-2011
How do I capture the whole row? In Excel, I can do a range; How do I do that with javascript?

Views

392

Likes

0

Replies

0
Re: SUMIFS formula - Adobe LiveCycle 24-02-2011
AB210Yes35Yes410NoSorry for the confusion on the table. I am actually trying to copy an excel spreadsheet

Views

392

Likes

0

Replies

0
Re: SUMIFS formula - Adobe LiveCycle 24-02-2011
Hi Bruce,Thank you however it did not work under JavaScript. Maybe I did it wrong because I am not very familiar with JavaScript; I have only used FormCalc in the past. Or maybe my question was not clear, but what I am trying to accomplish is to write a script similar to the following excel formula:=SUMIFS(A2:A4,B2:B4,"Yes")should the table look like this:Header 1Column AColumn BRow 110YesRow 25YesRow 310NoI found "if" scripts online, however I am not sure who to sum it up.Again, thank you.

Views

397

Likes

0

Replies

0
SUMIFS formula - Adobe LiveCycle 24-02-2011
Hi there,Can somebody please help me out with a formula? I am creating a form using LiveCycle Designer which will require a script equivalent to the SUMIFS on Excel. What I am trying to do is sum up all "yes" costs column which is relative to a yes/no dropdown column. I have been trying to research this for two days now and still no luck. I really hope someone could help me out.Thanks in advance.

Views

3.0K

Likes

0

Replies

15