Upcoming database upgrades. to improve our reliability at 03:30 UTC on Feb. 25 / 7:30pm PT on Feb. 24. Some users may briefly experience slow load times or error messages. Learn more here

Conditional sum formula

Topic Labels: Formulas
206 0
Showing results for 
Search instead for 
Did you mean: 

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.

0 Replies 0