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

Hi Ceej,

Which column do you want the added figures to show in?

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

Sorry - Colume B

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.

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

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.

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.