Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.

- Home
- >
- Acrobat SDK
- >
- SUMIF in Adobe pro XI, equivalent to Excel=SUM.IF(...

SUMIF in Adobe pro XI, equivalent to Excel=SUM.IF(C7:C68;C78;D7:D68

New Here
,

Jan 25, 2018

Copy link to clipboard

Copied

I have tried every SUMIF formula on these forums. But none of them worked for me. So I really need your help to complete my formula.

W | 20,00 |

G | 80,00 |

W | 23,00 |

G | 40,00 |

W | 0,05 |

G | 2,00 |

W | 5,00 |

G | 10,00 |

W | 70,00 |

G | 45,00 |

What I am trying to do is get the total of all the amounts behind "W" and behind "G". So in this case it would be W= € 118,05 and G= € 177(These outcomres will come in "Text1.1" And in Text1.2".

The row (from top to bottom) with G and W are called "Text9" and the second row is called "Text10". In the rows there are 61 lines (Text9.1/Text9.2/Text9.3 etc).

Can somebody please help me with this formula

TOPICS

Acrobat SDK and JavaScript,
Macintosh,
Windows

Community Guidelines

Be kind and respectful, give credit to the original source of content, and search for duplicates before posting.
Learn more

SUMIF in Adobe pro XI, equivalent to Excel=SUM.IF(C7:C68;C78;D7:D68

New Here
,

Jan 25, 2018

Copy link to clipboard

Copied

I have tried every SUMIF formula on these forums. But none of them worked for me. So I really need your help to complete my formula.

W | 20,00 |

G | 80,00 |

W | 23,00 |

G | 40,00 |

W | 0,05 |

G | 2,00 |

W | 5,00 |

G | 10,00 |

W | 70,00 |

G | 45,00 |

What I am trying to do is get the total of all the amounts behind "W" and behind "G". So in this case it would be W= € 118,05 and G= € 177(These outcomres will come in "Text1.1" And in Text1.2".

The row (from top to bottom) with G and W are called "Text9" and the second row is called "Text10". In the rows there are 61 lines (Text9.1/Text9.2/Text9.3 etc).

Can somebody please help me with this formula

TOPICS

Acrobat SDK and JavaScript,
Macintosh,
Windows

Community Guidelines

Be kind and respectful, give credit to the original source of content, and search for duplicates before posting.
Learn more

p_agard

Jan 25, 2018
0
/t5/acrobat-sdk/sumif-in-adobe-pro-xi-equivalent-to-excel-sum-if-c7-c68-c78-d7-d68/td-p/9636342
2
Replies
2

Most Valuable Participant
,

Feb 05, 2018

Copy link to clipboard

Copied

Let's say you have 10 such rows. Use this code as the custom calculation script for the field that should hold the total value for "G":

var totalG = 0;

for (var i=1; i<=10; i++) {

var v = this.getField("Text9."+i).valueAsString;

if (v=="G") totalG+=Number(this.getField("Text10."+i).valueAsString);

}

event.value = totalG;

You can adjust this code (by changing the condition in line #4 to *v=="W"*) for the second total field.

Community Guidelines

Be kind and respectful, give credit to the original source of content, and search for duplicates before posting.
Learn more

Reply

Loading...

try67

Feb 05, 2018
1
/t5/acrobat-sdk/sumif-in-adobe-pro-xi-equivalent-to-excel-sum-if-c7-c68-c78-d7-d68/m-p/9636343#M25156
p_agard
LATEST

New Here
,

Feb 05, 2018

Copy link to clipboard

Copied

Community Guidelines

Reply

Loading...

p_agard

Feb 05, 2018
0
/t5/acrobat-sdk/sumif-in-adobe-pro-xi-equivalent-to-excel-sum-if-c7-c68-c78-d7-d68/m-p/9636344#M25157
Using the Community
Experience League
Terms of Use
Privacy Policy
Cookie preferences
AdChoices
Language:

- Deutsch
- English
- Español
- Français
- 日本語コミュニティ
- Português

Copyright © 2020 Adobe. All rights reserved.