I have attached a PNG image file
that hopefully helps visually.
creating an Infopath 2010 form that has a section where users will manually
enter Account Numbers and Amounts.
Depending on the user, the Account Number values entered could be less
than 199999 or there could be a mix between Account Number values that are less
that 199999 or more than 199999.
formula that will operate similar to an Excel SUMIF formula. Sum the amounts in the 'Amount' column that
have Account Number values less than 199999.
The formula will ignore Account Numbers that have values higher than
‘Amount’ should appear in the Text Box field Tot1Accts. Amount needs to be numeric to use in another
calculation on the form.
Formulas are killing me ... is there a place in this forum or on the web that explains how to write formulas?