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
1717.40

  • 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.

https://hctny-my.sharepoint.com/:i:/g/personal/office_highclasstravel_com/EesBZqFYxQpIvxnKzbAVLu8Bs6pO4BEkdNQWgzHui4Gj_g?e=4zSeTF

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