Need Formula to Count Amount of Items
Good Afternoon All,
My company is conducting a baggage survey where we must record all types and weights of baggage during the operation. My form is set up as items 1-20, as well as weights 1-20. I had no problem creating a total weight field, but I need a formula field that counts the amount of items. The item field has words instead of numbers (such as personal bag, checked bag, crew bag, etc.), so I need a formula that will count any of these as 1 and then total it up.
Appreciate any help you can offer!
Aidon
------------------------------
Aidon Olligschlager
------------------------------
My company is conducting a baggage survey where we must record all types and weights of baggage during the operation. My form is set up as items 1-20, as well as weights 1-20. I had no problem creating a total weight field, but I need a formula field that counts the amount of items. The item field has words instead of numbers (such as personal bag, checked bag, crew bag, etc.), so I need a formula that will count any of these as 1 and then total it up.
Appreciate any help you can offer!
Aidon
------------------------------
Aidon Olligschlager
------------------------------
