Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 02-20-2017, 05:25 PM
Oleg Oleg is offline Formula for calculating total when number and letter in one cell Mac OS X Formula for calculating total when number and letter in one cell Office for Mac 2011
Novice
Formula for calculating total when number and letter in one cell
 
Join Date: Feb 2017
Posts: 3
Oleg is on a distinguished road
Default 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.
Reply With Quote
  #2  
Old 02-20-2017, 11:19 PM
xor xor is offline Formula for calculating total when number and letter in one cell Windows 10 Formula for calculating total when number and letter in one cell Office 2016
Expert
 
Join Date: Oct 2015
Posts: 1,097
xor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to all
Default

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

=LOOKUP(9^9,--LEFT(B2,ROW($1:$100)))
Reply With Quote
  #3  
Old 02-20-2017, 11:26 PM
Oleg Oleg is offline Formula for calculating total when number and letter in one cell Mac OS X Formula for calculating total when number and letter in one cell Office for Mac 2011
Novice
Formula for calculating total when number and letter in one cell
 
Join Date: Feb 2017
Posts: 3
Oleg is on a distinguished road
Default

Hello,

Thank you a lot.

It doesn't work...(
Reply With Quote
  #4  
Old 02-21-2017, 04:22 AM
xor xor is offline Formula for calculating total when number and letter in one cell Windows 10 Formula for calculating total when number and letter in one cell Office 2016
Expert
 
Join Date: Oct 2015
Posts: 1,097
xor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to all
Default

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.
Reply With Quote
  #5  
Old 02-22-2017, 12:21 AM
Oleg Oleg is offline Formula for calculating total when number and letter in one cell Mac OS X Formula for calculating total when number and letter in one cell Office for Mac 2011
Novice
Formula for calculating total when number and letter in one cell
 
Join Date: Feb 2017
Posts: 3
Oleg is on a distinguished road
Default

Thank you a lot for your help.

Here you go:
Attached Files
File Type: xls Order list sample.xls (35.5 KB, 11 views)
Reply With Quote
  #6  
Old 02-22-2017, 03:05 AM
xor xor is offline Formula for calculating total when number and letter in one cell Windows 10 Formula for calculating total when number and letter in one cell Office 2016
Expert
 
Join Date: Oct 2015
Posts: 1,097
xor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to all
Default

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

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Formula for calculating total when number and letter in one cell Calculating multiple fields to calculate to the total hours stewbinson Excel 1 01-22-2017 10:18 PM
Formula for calculating total when number and letter in one cell Calculating the “total” based on “salary” value and its “type” (multiple IF), Jamal NUMAN Excel 4 07-05-2016 12:34 AM
Formula for calculating total when number and letter in one cell Formula, Compare two cell's text and based on results output a number Offrddrver Excel 4 03-23-2016 11:32 PM
Formula for calculating total when number and letter in one cell Formula in cell b1 using cell a1 if a1 is over certain number pumkinbug87 Excel 5 12-03-2013 12:34 PM
Formula for calculating total when number and letter in one cell formula help with total in same cell jterr Excel 14 02-25-2013 05:43 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 12:47 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft