#1
|
|||
|
|||
Formula for calculating total when number and letter in one cell
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. |
#2
|
|||
|
|||
If you have for example 3Q in B2 try the following formula:
=LOOKUP(9^9,--LEFT(B2,ROW($1:$100))) |
#3
|
|||
|
|||
Hello,
Thank you a lot. It doesn't work...( |
#4
|
|||
|
|||
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. |
#5
|
|||
|
|||
Thank you a lot for your help.
Here you go: |
#6
|
|||
|
|||
Please show in the sheet where you want to do your calculations and what the result should be.
|
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Calculating multiple fields to calculate to the total hours | stewbinson | Excel | 1 | 01-22-2017 10:18 PM |
Calculating the “total” based on “salary” value and its “type” (multiple IF), | Jamal NUMAN | Excel | 4 | 07-05-2016 12:34 AM |
Formula, Compare two cell's text and based on results output a number | Offrddrver | Excel | 4 | 03-23-2016 11:32 PM |
Formula in cell b1 using cell a1 if a1 is over certain number | pumkinbug87 | Excel | 5 | 12-03-2013 12:34 PM |
formula help with total in same cell | jterr | Excel | 14 | 02-25-2013 05:43 PM |