Skip to main content
Question

Formula Field - Sums Multiple Fields with Filtered Criteria

  • November 30, 2022
  • 0 replies
  • 125 views
Forum|alt.badge.img+6
Hello All,

I need a formula for a field that sums up the total weight of specific bags in my table.

I currently have 25 Text-Multiple Choice fields titled "Item 1," "Item 2," etc., and 25 numeric fields titles "Weight 1," "Weight 2," etc.​  Each Item field has 4 choices.  One of which is "Checked Bag," and then the relevant weight is displayed in the corresponding weight field based by number. 

I need a formula that sums up the total weight of all items (1-25), if the item field is equal to "Checked Bag."

Hoping for a simple fix here.  Thanks,

------------------------------
Aidon Olligschlager
------------------------------
    This topic has been closed for replies.

    Forum|alt.badge.img+6
    To update, I have figured out how to pull the values I need and am testing it on the first couple entries.  However, I cannot figure out how to get the formula to add up all the values, rather than just display the values I'd like to pull.  See attached photos for reference.

    ------------------------------
    Aidon Olligschlager
    ------------------------------
    Forum|alt.badge.img+6
    To conclude, I did end up figuring out a solution:

    First step was to use a Numeric Formula field instead of a Text Formula.  I attached the solution in the file section.

    Thanks!

    ------------------------------
    Aidon Olligschlager
    ------------------------------
    Terms & ConditionsAccessibility statement