Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Function help
A B C D E F G H I
124504501800 170 TN439 14-May 160 06/04/12 TN440 124504501800 80 124504501100 36 TN440 14-May 160 06/04/12 TN440 124504501100 168 126636631800 86 TN439 14-May 90 06/04/12 TN440 124504501800 120 I am trying to work up a formula that would allow me to add quantity received (I) to quantity on hand (B) by part numbers (H). For example: If the item number is 124504501800 and I received 80 pieces in I would like a formula to add this to my existing inventory under that part number. Does this make sense? The cell columes are A-I above....and 1-3 Rows Thanks Ceej |
#2
|
|||
|
|||
Quote:
Which column do you want the added figures to show in? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Function help
Ceej76 used his keyboard to write :
A B C D E F G H I 124504501800 170 TN439 14-May 160 06/04/12 TN440 124504501800 80 124504501100 36 TN440 14-May 160 06/04/12 TN440 124504501100 168 126636631800 86 TN439 14-May 90 06/04/12 TN440 124504501800 120 I am trying to work up a formula that would allow me to add quantity received (I) to quantity on hand (B) by part numbers (H). For example: If the item number is 124504501800 and I received 80 pieces in I would like a formula to add this to my existing inventory under that part number. Does this make sense? The cell columes are A-I above....and 1-3 Rows Thanks Ceej In the cell to recieve the new quantity, type =B1+I1 (adjust for the actual row number and copy down. -- Garry Free usenet access at http://www.eternal-september.org ClassicVB Users Regroup! comp.lang.basic.visual.misc microsoft.public.vb.general.discussion |
#4
|
|||
|
|||
Sorry - Colume B
|
#5
|
|||
|
|||
Quote:
Garry - I would like it to search for the item number and adjust it automatically when I add the new inventory of the same item number. |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Function help
Ceej76 explained :
'GS[_2_ Wrote: ;1602491']Ceej76 used his keyboard to write :- A B C D E F G H I 124504501800 170 TN439 14-May 160 06/04/12 TN440 124504501800 80 124504501100 36 TN440 14-May 160 06/04/12 TN440 124504501100 168 126636631800 86 TN439 14-May 90 06/04/12 TN440 124504501800 120 I am trying to work up a formula that would allow me to add quantity received (I) to quantity on hand (B) by part numbers (H). For example: If the item number is 124504501800 and I received 80 pieces in I would like a formula to add this to my existing inventory under that part number. Does this make sense? The cell columes are A-I above....and 1-3 Rows Thanks Ceej- In the cell to recieve the new quantity, type =B1+I1 (adjust for the actual row number and copy down. -- Garry Free usenet access at http://www.eternal-september.org ClassicVB Users Regroup! comp.lang.basic.visual.misc microsoft.public.vb.general.discussion Garry - I would like it to search for the item number and adjust it automatically when I add the new inventory of the same item number. Perhaps, then, you should look at the SUMIF() function or maybe the SUMPRODUCT() function in the Excel Function Reference section of online help. -- Garry Free usenet access at http://www.eternal-september.org ClassicVB Users Regroup! comp.lang.basic.visual.misc microsoft.public.vb.general.discussion |
#7
|
|||
|
|||
Quote:
I have tried all that - I think I am doing something wrong - because it doesn't work. That is why I am asking for help, because I can't figure it out. |
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Function help
hi,
=SUMPRODUCT(--($H$1:$H$10=H1)*($I$1:$I$10)) -- isabelle Le 2012-06-08 17:15, Ceej76 a écrit : I have tried all that - I think I am doing something wrong - because it doesn't work. That is why I am asking for help, because I can't figure it out. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel Data Validation/Lookup function does function correcty | Excel Worksheet Functions | |||
User Function Question: Collect Condition in Dialog Box - But How toInsert into Function Equation? | Excel Programming | |||
LINKEDRANGE function - a complement to the PULL function (for getting values from a closed workbook) | Excel Worksheet Functions | |||
Excel - User Defined Function Error: This function takes no argume | Excel Programming | |||
Need to open the Function Arguments window from VBA for a user defined function. | Excel Programming |