
Can I Add A Quantity To Every Cell In A Column Using A Formula?


Search Excel Forum Posts, Tutorials, Macros, Tips, and More
Can I Add A Quantity To Every Cell In A Column Using A Formula?  Excel

View Answers


Is there a formula to use to add a quantity to every cell in a column?
I need to be able to add a quantity of 3 to every row in a column.
Any help would be appreciated.
Thanks!
Similar Excel Video Tutorials
Names Cell If Name in Cell
 See how to name individual cells a name that is the cell content (the name of the cell is in the cell). To do this: 1) Put names in column B, 2) copy ...
Cell References Relative & Absolute
 The Excel Basics Series shows a systematic description of what Excel can do from beginning to end. #8 Video topics: 1)Cell references in for ...
Similar Topics
Hi,
I have a problem I hope you can help me with. I am working on a pricelist that has different quantity breaks. I am try to get subsequent cells to automatically generate the correct quantity according to what is in the previous quantity cell. So for example, if the first quantity is 50, the next needs to be 100. In most cases, like in the above example, the quantity just doubles.
However, there are a few exceptions and this is where I am stuck. For example, if a number is quantity is 12, the next one needs to be 25, or if a quantity is one, the next needs to be 5.
I have built the following formula, but can't get it to work. Help, please!
=if(X9*2,(IF(X9<=4,5,IF(X9<=24,25,IF(X9<=249,250,IF(X9=300,500,IF(X9=1000,2500,IF(X9=10000,25000)))) )))))
in the formula above, X9 represents the first quantity.
Many thanks and I look forward to hearing from you.
Fionn
I have a sheet that has the following format:
Row 1, Column A = Kit ID 1
Row 1, Column B = Quantity 1
Row 1, Column C = name 1
Row 1, Column D = Quantity 2
Row 1, Column E = Name 2
Row 2, Column A = Kit ID 2
Row 2, Column B = Quantity 1
Row 2, Column C = name 1
etc...
The quantities and name can go up to column BD depending on how many items are associated with each kit id.
What I am trying to do is break the information up and make the data appear as Kit ID, Quantity, Name and then break to the next row where it will again have Kit ID, Quantity, Name:
Row 1, Column A = Kit ID 1
Row 1, Column B = Quantity 1
Row 1, Column C = Name 1
Row 2, Column A = Kit ID 1
Row 2, Column B = Quantity 2
Row 2, Column C = Name 2
etc.. until all info from row 1 is done then
Row x, Column A = Kit ID 2 etc.
Can someone point me in the right direction on how to go about this? Any help is very much appreciated.
Thanks
Hii.
In a worksheet, column "B" includes the "Quantity". There are around 150 Items in Column "A", in front of these items, quantity remaining comes in cells of column "B". I have used formula to get the value of quantity from different files.
A B
Item Quantity
XYZ 15
RST 0
ABC 8
I need that if quantity is 0(zero), the complete row hides automatically.
when using vlookup, how do you direct the formula to look for a text string in a column, and use the data in the column to the immedate right of that column?
for example sometimes we put product A, quantity of product A in col 1 & 2 respectively, and sometimes product A, quantity of product A in col 3&4 or 9&10.
regardless where I put product A, and it's corresponding quantity, I want the quantity to go to the proper inventory column on the inventory page.
currently we enter the quantity by "tabing" to the correct column. If someone enters the quantity in the wrong column, our inventory gets messed up.
Can someone help me?
I have a table that looks like this:
Column 1: ID
Column 2: January '07 quantity
Column 3: February '07 quantity
Column 4: March '07 quantity
Column 5: April '07 quantity
...
Column 54: June '11 quantity
I want to create a new simplified table that has three columns
Column1: ID
Column2: Month
Column3: Quantity
Is there an easy way to do this without creating 54 separate append queries?
Is there an easy
Hi
this is very dynamic requirement.
I have attached image as well sample sheet for what i need.
In brief:
I want to transfer(cut or moving) the cells to respective column but on same row from where is has been cut.
For example: (where , (comma) means different column
Account No.1
item33,quantity,amount,
item2,quantity,amount,
item48,quantity,amount,
Account No.2
item9,quantity,amount,
Account No.3
item19,quantity,amount,
item2,quantity,amount,
item6,quantity,amount,
item75,quantity,amount,
item52,quantity,amount,
Now i want put it like this
Account No.1 item33,quantity,amount,
Account No.1 item2,quantity,amount,
Account No.1 item48,quantity,amount,
Account No.2 item9,quantity,amount,
Account No.3 item19,quantity,amount,
Account No.3 item2,quantity,amount,
Account No.3 item6,quantity,amount,
Account No.3 item75,quantity,amount,
Account No.3 item52,quantity,amount,
I have also attached image and sample excel file.
Thanks
Hi everyone, I'm in need of some assistance.
I have a spreadsheet. In column A, I have a unique identifier number. In column B, I have a quantity. My problem is there are around ~600 duplicates. Ex:
ID  Quantity
23  4
23  8
24  4
25  4
I want to remove the extra ID, but sum the quantity value together, is this possible?
Ex (following from above):
ID  Quantity
23  12
24  4
25  4
Any help is appreciated. Thanks!
Hello!
I need some help please ....I need a formula that will calculate the quantity of each size of an item (XS,S,M,L,XL). For example to calculate the quantity for Mediums, I need the formula to look at column C, if M is entered, then look at the adjacent cell in column A for the quantity and formulate a total number (from rows 421) and enter the total quantity in C27.
See attachment.
Thanks for your help! Kim
in first cell (A1) i have a code: 553282300000
in second cell (B1) quantity: 50
and in third cell (C1) i have first 2 numbers from first cell (A1), in that case 55.
In second row, first cell (A2) i have another code, but begins with 55 too, in second cell (B2) i have quantity for this: 160.
Here is the example:
Code........................Quantity
553282300000............... 50........................55
553290240040..............160........................58
553480480020..............420........................7E
553492300040............... 20
583182300060SMA.......100
585281100060SMA........ 80
7E1382300000................15
7E1682300000................38
7E3684000000................73
7E3684000002................57
What i have to do is to sum the quantity of the products that begin with 55 in "C1", quantity of the products that begin with 58 in "C2" and the quantity of products that begin with 7E in "C3".
Can someone help me?
Thank you!
I have a list of data.. I wish to make column "A" numbers random. Is there a way to do it?
ORIGINAL
1...keyboard....quantity 1
2...fan coil...quantity 4
3...mouse...quantity 2
4...staples...quantity 7
5...menu...quantity 3
6...thumbdrive...quantity 1
etc
RESULT
1...staples...quantity 7
2...thumbdrive...quantity 1
3...fan coil...quantity 4
4...mouse...quantity 2
5...keyboard....quantity 1
6...menu...quantity 3
etc
I have a huge amount of data which i would like to keep consistent.
In 1 cell i have a quantity and in another cell in a different column i have the quantity to date value. I know how to make it so the quantity to date cell does not exceed the planned quantity but is there a way of repeating this for hundreds of situations rather that data validate every single cell, just like if you were dragging a formula through a range of cells?
please help
in first cell (A1) i have a code: 553282300000
in second cell (B1) quantity: 50
and in third cell (C1) i have first 2 numbers from first cell (A1), in that case 55.
In second row, first cell (A2) i have another code, but begins with 55 too, in second cell (B2) i have quantity for this: 160.
Here is the example:
Code........................Quantity
553282300000............... 50........................55
553290240040..............160........................58
553480480020..............420........................7E
553492300040............... 20
583182300060SMA.......100
585281100060SMA........ 80
7E1382300000................15
7E1682300000................38
7E3684000000................73
7E3684000002................57
What i have to do is to sum the quantity of the products that begin with 55 in "C1", quantity of the products that begin with 58 in "C2" and the quantity of products that begin with 7E in "C3".
NOTE: OP requires VBA solution  WF solution provided previously he related thread: http://www.excelforum.com/excelwork...stcolumn.html
(D.O)
Hello All,
I have a inventory question that I need help with.
Lets say cell:
A1=Quantity in stock (person enters)
B1=Quantity used per day (person enters)
C1=Quantity used per week (person enters)
D1=Reorder Level (Person enters)
E1=Status (Condition formula)
What I need formulas for are
1. Subtract quantity used per day(b1) or quantity used per week (C1) from quantity in stock (a1). Then I want the total of this (a1b1 or c1) to replace the quantity in A1 as the new quantity in stock.
After the calculation is completed I am looking for a formula that then clears the cells (B1 or C1) for the next entry (the next day/week).
2. A status formula that will state when A1 (quantity stock) is above the reorder level (d1) the cell (e1) will be green and say In Stock, otherwise if a1 is less than or equal to d1 then state Need to order, and turn cell e1 yellow.
If anyone can help I would really appreciate it!!! I would even pay for your time invested if I need to!!
Thanks!!
Hi,
I'm working on some VBA to reformat some quotations to a more basic layout for data entry. The reformatted sheet is very simple containing just the product code in column A and the quoted quantity in column B.
A colleague has asked me if the quantities could be ommitted but if the quantity is greater than 1 then it should duplicate the code underneath the original (duplicate once for a quantity of 2 or twice for a quantity of 3 and so on).
I'm not really even sure where to start with this  can anyone help?
Ok, so here's the situation:
I have one static cell, in this case it's "F48" and I need it to equal the sum that I have at the bottom of another range of data. That range of data always changes in the amount of rows, however the columns are static. In column "J" is the part number, column "K" is the description, column "L" is the quantity, and the only purpose of column "M" is to label the total quantity at the very bottom of the data where everythign is summed.
I can't simply just do a sum formula in the F48 cell because of how everything is arranged and how it changes. Basically, I just need code that looks for the term "Polarized" in column "M", and takes the total quantity that is in the cell directly to the left of it, and copy that quantity into F48.
Any ideas?
Help. What I need to do:
I have a spreadsheet with a list of products, quantity, descriptions, discounts, etc., used to prepare estimates and orders.
Each row is an item and information to configure item cost. I have an item quantity in column (A). I have a numerical Pts in column (L).
I have a reference table at the top with y value ranges (1, 25, 617, 1847, etc), to select from the quantity in column A. The x values are number ranges (pts) (05000, 500110000, 1000120000, over 20000.) to select from column L.
I need a formula for a cell in the same item row (J), determined by table value from quantity and points.
Summary: I have to enter a value used to determine pricing, which is based on quantity and stitch count for embroideries.
Help anyone?
Box Size (units that can be placed inside)
F G H I J K
Quantity
1  7
units
8  30 units
31  40 units
41  84 units
>84
8
0
1
0
0
0
4
1
0
0
0
0
4
1
0
0
0
0
7
1
0
0
0
0
7
1
0
0
0
0
210
0
0
0
0
3
7
1
0
0
0
0
7
1
0
0
0
0
4
1
0
0
0
0
14
0
1
0
0
0
70
0
0
0
1
0
I have this table with me which follows the quantity and the units (boxes required) that is involved when it is within range
the formula for B=IF(AND(F2>0,F27,F230,F240,F284),F2/84,0)
Lets look at row 6 where the quantity is 210 and the box that is needed is 3.
What i want is that the quantity of the range higher than 84 is 2 and the rest is given to the columns that can take the quantity of the its balance
example= 210/84= 2.5 which equals to 2 box (that can fill 84 units each)
and 1 box that can fill 42 units which is the box @ column J.
How can i do this? what formula to use?
Please help me, Excel Guru
I am looking for a way to automate the goal seek tool in excell or write a formula to find the "Quantity 3" below.
I have a column of 100 items that are variable and to calculate them one at a time is way to slow
The feilds I am dealing with are
"Quantity 1" = $6760
"Sell Price 1" =$1,882
"Quantity 2" = $27,038
Sell Price 2 = $2,698
Goal Unit price =.10
"Quantity 3"= Goal Quantity that needs to be determined with a Goal seeker formula that will create a unit Price that matches a Goal Unit Price
"Sell Price 3"= Formula that interpolates from "Quantity 1", "Sell Price 1" and "Quantity 2", "Sell Price 2" using Qty 3 as its variable
"Unit price 3" = Formula = Sell Price 3/Quantity 3 (This needs to match the Goal Unit price
This is my 1st post, Thank you for any help
Jim
Anyone Who Can Help:
I have a formula that is much too long which takes into account the quantity of a product that potential customers could buy and the price of each product.
I know there is a way of shortening and condensing the formula I currently am using which is what I need.
The current formulas goes through 17 different product categories and then multiplies the price by the quantity.
I.E. sum((A1*B1),(D1*E1),.....) The "...." goes out for 17 different products on the sheet.
This is where A1 is the Quantity and B1 is the Price of the first product, D1 is the Quantity of the second product and E1 is the price of the second product.
Attached is the spreadsheet for easier explanation. The formula I'm searching for needs to be in column EJ.
Any help is appreciated.
I have 3 columns:
in first cell (A1) i have a code: 553482300040
in second cell (B1) quantity: 1000
and in third cell (C1) i have first 2 numbers from first cell (A1), in that case 55.
In second row, first cell (A2) i have another code, but begins with 55 too, in second cell (B2) i have quantity for this: 500.
What i have to do is to sum the quantity of the products in third cell, row 1 (A3).
Can someone help me?
Thank you!
Here's my situation, I've got over 1000 inventory items in a column with the Quantity of each in the column next to it. I'm trying to make it easy to find the item without scrolling through the list.
The item name and quantity are setup in two columns, column a and column b. I would like to have a cell where you enter the items name and once you hit return, it will take you to the the item in the column and then highlight the quantity.
My question is, would INDEX or MATCH be the best choice for this? In addition, what would the best formula be for such a thing.
I've got a problem that I've been trying to solve for most of the day. Let me try to lay it out for you.
If have my data arranged horizontally for ease of entry and I would like to sum certain cells if certain conditions are met.
DATA ARRANGEMENT
Column B: Customer Name
Column C: PO#
Column D: PO Date
Column E: Type
Column F: Total Quantity
Column G: Ship Date
Column H: Quantity to Ship
Column I: Ship Date
Column J: Quantity to Ship
Column K: Ship Date
Column L: Quantity to Ship
Column M: Ship Date
Column N: Quantity to Ship
Column O: Ship Date
Column P: Quantity to Ship
Column Q: Ship Date
Column R: Quantity to Ship
Columns G through R reflect the fact that multiple shipments are often made on one purchase order.
I would like to sum the values in columns H, J, L, N, P, R based on whether the Customer Name and Type in the row match the same values on another worksheet and based on whether the date to the left of Quantity falls within a given month.
The data on my reporting spreadsheet is arranged as follows:
Column A: Customer Name
Column D: Quantity (where the sum would be reported)
Cell A2: Type
I would like to end up with the quantity to be shipped in a given month for a given customer and type.
The thing that seems to be giving me the biggest problem is that one of the criteria is referring to a value that to the left of the numbers that I want to sum and therefore part of the Sum Range.
Please help!!!
Thanks!
I have a spreadsheet with a drop down list of items (column A), selecting an item in column A automatically fills the price in column C. In column B I want to put the quantity. Please can you help me with what formula I would need to use to put an automatic quantity of 1 in the quantity column if there is an item in column A selected, but if there is no item selected then a value of nothing should be returned, as in the box should be blank.
I have tried several if formulas to achieve this but none of them seem to work correctly.
Many thanks.
I have two columns as No.of persons & other quantity.Quantity is depend upon the following criteria. If the no of perons is between 14 the quantity will be 40, and if no.of person is betwenn 58 then 80 kg, if no of person increased from 8 then quantity 160kg. I applied the the formula =if(no
Hello All,
I have a inventory question that I need help with.
Lets say cell:
A1=Starting Quantity in stock (Person Enters)
B1=Quantity in stock (Formula)
C1=Quantity used per day (person enters, then calculates, then cell clears)
D1=Quantity used per week (person enters, then calculates, then clears)
E1=Reorder Level (Person enters)
F1=Status (Condition formula)
P/E=Person Enters
Starting Quantity
Quantity in Stock
Used Today
Used This Week
Reorder Level
Status
P/E
Formula
P/E then Clear
P/E then clear
P/E
Condition formula
What I need formulas for are
1. Subtract quantity used per day(b1) or quantity used per week (C1) from quantity in stock (b1). Then I want the total of this (a1b1 or c1) to replace the quantity in b1 as the new quantity in stock.
After the calculation is completed I am looking for a formula that then clears the cells (B1 or C1) for the next entry (the next day/week).
2. A status formula that will state when b1 (quantity stock) is above the reorder level (d1) the cell (e1) will be green and say In Stock, otherwise if a1 is less than or equal to d1 then state Need to order, and turn cell e1 yellow.
If anyone can help I would really appreciate it!!! I would even pay for your time invested if I need to!!
Thanks!!

