Function help

[Ceej76]

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 quantit
received (I) to quantity on hand (B) by part numbers (H).

For example: If the item number is 124504501800 and I received 8
pieces in I would like a formula to add this to my existing inventor
under that part number.

Does this make sense?

The cell columes are A-I above....and 1-3 Rows

Thanks

Cee

 

[Spencer101]

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 quantit
received (I) to quantity on hand (B) by part numbers (H).

For example: If the item number is 124504501800 and I received 8
pieces in I would like a formula to add this to my existing inventor
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

 

[GS]

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

 

[Ceej76]

Hi Ceej,

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

Sorry - Colume

 

[Ceej76]

;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 i
automatically when I add the new inventory of the same item number

 

[GS]

Ceej76 explained :

;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

 

[Ceej76]

;1602513']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 ad 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 existin 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 fo 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 onlin

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 i
doesn't work. That is why I am asking for help, because I can't figur
it out

 

[isabelle]

hi,

=SUMPRODUCT(--($H$1:$H$10=H1)*($I$1:$I$10))

--
isabelle



Le 2012-06-08 17:15, Ceej76 a écrit :