AidonOlligschla

2 years agoQrew Cadet

# 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

------------------------------

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

------------------------------