Avatar

Level 2

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 1
Column A
Column B
Row 110Yes
Row 25Yes
Row 310No

I found "if" scripts online, however I am not sure who to sum it up.

Again, thank you.