Conditional sum formula

I would like to create a formula that will:

Sum the {Amt} fields only from records that have the identical data in another field {ticket/voucher #}.

For example:
Records 1, 7 and 14 have the identical data in {Ticket/Voucher #}. The formula would sum the amounts only from those records

  • 980.00
  • 250.00
    and put the total 487.40 in {Formula field}.

The same would go for records 10, 12 and 15
and 11, 16 and 13.
See link to image of my table.

This topic was solved and automatically closed 15 days after the last reply. New replies are no longer allowed.