Hello everyone.



I'm currently working with order sheets for flavoring company.
When customer want to order flavor he need to put number (1,2,3,4,5 etc.) that means quantity of kg, and letter (like Q, K, C etc) that means which packaging of this kg.
After customer fill up order sheet - putting everywhere number and letter - I can't anymore calculate in Excel what is the total order, and I need to calculate in by calculator.
Order sheet consist of 5 columns:
- name of flavor
- and 4 columns to the right to put number and letter there for the order

It is important number and letter stay at same cell for production.

Can someone advice me better solution how to calculate
- maybe formula that will count only number and disregard letters.
- or formula where I can add letter to entire table where I have number after I get total for each column.

Hope I explained it well and really hope someone can help me.

Thank you a lot everyone.

If you have for example 3Q in B2 try the following formula:

=LOOKUP(9^9,--LEFT(B2,ROW($1:$100)))

Hello,

Thank you a lot.

It doesn't work...(

It is not of much help to know that it doesn't work. Do you get error values or what?

If I shall do more, please upload a sheet with examples of your data and expected results.

Thank you a lot for your help.

Here you go:

Attached Files

Order list sample.xls (35.5 KB, 13 views)

Please show in the sheet where you want to do your calculations and what the result should be.