Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Conditional sum formula

Topic Labels: Formulas
708 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