Help

Conditional sum formula

Topic Labels: Formulas
420 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Accounts_Accoun
4 - Data Explorer
4 - Data Explorer

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/EesBZqFYxQpIvxnKzbAVLu8Bs6...

0 Replies 0