I am attempting to create an invoice in InfoPath 2007.
Right now I am attempting to take a series of currency fields, check if their check box is selected (TRUE) and only add together the fields that are associated with the selected check boxes.
In Excel it is easy with =SUMIF(E17:E32,"=x",F17:F32)
However, I am not finding anything similar in Infopath, and my web searches are not proving fruitful.
Any advice?
Right now I am attempting to take a series of currency fields, check if their check box is selected (TRUE) and only add together the fields that are associated with the selected check boxes.
In Excel it is easy with =SUMIF(E17:E32,"=x",F17:F32)
However, I am not finding anything similar in Infopath, and my web searches are not proving fruitful.
Any advice?