Forum Discussion

AidonOlligschla's avatar
AidonOlligschla
Qrew Cadet
3 years ago

Formula Field - Sums Multiple Fields with Filtered Criteria

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
------------------------------
  • AidonOlligschla's avatar
    AidonOlligschla
    Qrew Cadet
    3 years ago
    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
    ------------------------------
  • AidonOlligschla's avatar
    AidonOlligschla
    Qrew Cadet
    3 years ago
    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
    ------------------------------