Ok, let me try this again.
I have 4 lipsticks which are represented in sheet 'Inventory Ordered' cell
E3. I want those lipstick to be represented by 10-6161. Everytime I type in
10-6161 in sheet 'Inventory Sold' column B I want it to subtract from
'Inventory Ordered' cell E3 and the results to show in 'Inventory In Stock'
cell D3.

Layout;
'Inventory Ordered' Cell E3 minus by part number 'Inventory Sold' column B
to = in 'Inventory In Stock' D3

If I can't work it out, would someone also be kind enough to walk me through
it once.

Hi
have you tried my suggestion and if yes what exactly does not work for you

P.S.: always better to stay in the original thread for follow-ups :-)

--
Regards
Frank Kabel
Frankfurt, Germany
"Crowraine" schrieb im Newsbeitrag
...
Ok, let me try this again.
I have 4 lipsticks which are represented in sheet 'Inventory Ordered' cell
E3. I want those lipstick to be represented by 10-6161. Everytime I type
in
10-6161 in sheet 'Inventory Sold' column B I want it to subtract from
'Inventory Ordered' cell E3 and the results to show in 'Inventory In
Stock'
cell D3.

Layout;
'Inventory Ordered' Cell E3 minus by part number 'Inventory Sold' column B
to = in 'Inventory In Stock' D3

If I can't work it out, would someone also be kind enough to walk me
through
it once.

I didn't know to stay in the same thread. I tried it but I am having issues
figuring it out. I have been figuring out these formulas as I go. So I don't
know what all the parts of that formula are for. Thank you for letting me
know about the thread.

Crowraine

"Frank Kabel" wrote:

Hi
have you tried my suggestion and if yes what exactly does not work for you

P.S.: always better to stay in the original thread for follow-ups :-)

--
Regards
Frank Kabel
Frankfurt, Germany
"Crowraine" schrieb im Newsbeitrag
...
Ok, let me try this again.
I have 4 lipsticks which are represented in sheet 'Inventory Ordered' cell
E3. I want those lipstick to be represented by 10-6161. Everytime I type
in
10-6161 in sheet 'Inventory Sold' column B I want it to subtract from
'Inventory Ordered' cell E3 and the results to show in 'Inventory In
Stock'
cell D3.

Layout;
'Inventory Ordered' Cell E3 minus by part number 'Inventory Sold' column B
to = in 'Inventory In Stock' D3

If I can't work it out, would someone also be kind enough to walk me
through
it once.

Do you have a column next to "10-6161" that has a 4 in it?


"Crowraine" wrote in message
...
Ok, let me try this again.
I have 4 lipsticks which are represented in sheet 'Inventory Ordered' cell
E3. I want those lipstick to be represented by 10-6161. Everytime I type
in
10-6161 in sheet 'Inventory Sold' column B I want it to subtract from
'Inventory Ordered' cell E3 and the results to show in 'Inventory In
Stock'
cell D3.

Layout;
'Inventory Ordered' Cell E3 minus by part number 'Inventory Sold' column B
to = in 'Inventory In Stock' D3

If I can't work it out, would someone also be kind enough to walk me
through
it once.

No. All the sheets, the part number is at least 3 columns over. But hey, if I
need to I can move it.

"Dave R." wrote:

Do you have a column next to "10-6161" that has a 4 in it?


"Crowraine" wrote in message
...
Ok, let me try this again.
I have 4 lipsticks which are represented in sheet 'Inventory Ordered' cell
E3. I want those lipstick to be represented by 10-6161. Everytime I type
in
10-6161 in sheet 'Inventory Sold' column B I want it to subtract from
'Inventory Ordered' cell E3 and the results to show in 'Inventory In
Stock'
cell D3.

Layout;
'Inventory Ordered' Cell E3 minus by part number 'Inventory Sold' column B
to = in 'Inventory In Stock' D3

If I can't work it out, would someone also be kind enough to walk me
through
it once.

The confusion on my part was that you said you wanted 10-6161 to "be
represented by 4".

It sounds like you want to count all the 10-6161 in column B and subtract
that number from the "inventory ordered" amount.

You can use a formula like

=COUNTIF(B:B,"10-6161") to count up the 10-6161s in B. You can also
reference the cell that contains the part number like =COUNTIF(B:B,$A1).

If those do what you want, just include the COUNTIF... part in the formula
that you want to show your inventory (subtracting it from the number you
have ordered. if it's in the same row it should be easy).



"Crowraine" wrote in message
...
No. All the sheets, the part number is at least 3 columns over. But hey,
if I
need to I can move it.

"Dave R." wrote:

Do you have a column next to "10-6161" that has a 4 in it?


"Crowraine" wrote in message
...
Ok, let me try this again.
I have 4 lipsticks which are represented in sheet 'Inventory Ordered'
cell
E3. I want those lipstick to be represented by 10-6161. Everytime I
type
in
10-6161 in sheet 'Inventory Sold' column B I want it to subtract from
'Inventory Ordered' cell E3 and the results to show in 'Inventory In
Stock'
cell D3.

Layout;
'Inventory Ordered' Cell E3 minus by part number 'Inventory Sold'
column B
to = in 'Inventory In Stock' D3

If I can't work it out, would someone also be kind enough to walk me
through
it once.

I do the COUNTIF but I want to subtract that from Sheet Inventory Ordered and
put the results in Sheet Inventory In Stock

"Dave R." wrote:

The confusion on my part was that you said you wanted 10-6161 to "be
represented by 4".

It sounds like you want to count all the 10-6161 in column B and subtract
that number from the "inventory ordered" amount.

You can use a formula like

=COUNTIF(B:B,"10-6161") to count up the 10-6161s in B. You can also
reference the cell that contains the part number like =COUNTIF(B:B,$A1).

If those do what you want, just include the COUNTIF... part in the formula
that you want to show your inventory (subtracting it from the number you
have ordered. if it's in the same row it should be easy).



"Crowraine" wrote in message
...
No. All the sheets, the part number is at least 3 columns over. But hey,
if I
need to I can move it.

"Dave R." wrote:

Do you have a column next to "10-6161" that has a 4 in it?


"Crowraine" wrote in message
...
Ok, let me try this again.
I have 4 lipsticks which are represented in sheet 'Inventory Ordered'
cell
E3. I want those lipstick to be represented by 10-6161. Everytime I
type
in
10-6161 in sheet 'Inventory Sold' column B I want it to subtract from
'Inventory Ordered' cell E3 and the results to show in 'Inventory In
Stock'
cell D3.

Layout;
'Inventory Ordered' Cell E3 minus by part number 'Inventory Sold'
column B
to = in 'Inventory In Stock' D3

If I can't work it out, would someone also be kind enough to walk me
through
it once.

You can reference other sheets in formulas, like
=COUNTIF('Inventory Ordered'!B:B,"10-6161")

"Crowraine" wrote in message
...
I do the COUNTIF but I want to subtract that from Sheet Inventory Ordered
and
put the results in Sheet Inventory In Stock

"Dave R." wrote:

The confusion on my part was that you said you wanted 10-6161 to "be
represented by 4".

It sounds like you want to count all the 10-6161 in column B and
subtract
that number from the "inventory ordered" amount.

You can use a formula like

=COUNTIF(B:B,"10-6161") to count up the 10-6161s in B. You can also
reference the cell that contains the part number like =COUNTIF(B:B,$A1).

If those do what you want, just include the COUNTIF... part in the
formula
that you want to show your inventory (subtracting it from the number you
have ordered. if it's in the same row it should be easy).



"Crowraine" wrote in message
...
No. All the sheets, the part number is at least 3 columns over. But
hey,
if I
need to I can move it.

"Dave R." wrote:

Do you have a column next to "10-6161" that has a 4 in it?


"Crowraine" wrote in message
...
Ok, let me try this again.
I have 4 lipsticks which are represented in sheet 'Inventory
Ordered'
cell
E3. I want those lipstick to be represented by 10-6161. Everytime
I
type
in
10-6161 in sheet 'Inventory Sold' column B I want it to subtract
from
'Inventory Ordered' cell E3 and the results to show in 'Inventory
In
Stock'
cell D3.

Layout;
'Inventory Ordered' Cell E3 minus by part number 'Inventory Sold'
column B
to = in 'Inventory In Stock' D3

If I can't work it out, would someone also be kind enough to walk
me
through
it once.

Oh, and with the COUNTIF.

"Crowraine" wrote:

I do the COUNTIF but I want to subtract that from Sheet Inventory Ordered and
put the results in Sheet Inventory In Stock

"Dave R." wrote:

The confusion on my part was that you said you wanted 10-6161 to "be
represented by 4".

It sounds like you want to count all the 10-6161 in column B and subtract
that number from the "inventory ordered" amount.

You can use a formula like

=COUNTIF(B:B,"10-6161") to count up the 10-6161s in B. You can also
reference the cell that contains the part number like =COUNTIF(B:B,$A1).

If those do what you want, just include the COUNTIF... part in the formula
that you want to show your inventory (subtracting it from the number you
have ordered. if it's in the same row it should be easy).



"Crowraine" wrote in message
...
No. All the sheets, the part number is at least 3 columns over. But hey,
if I
need to I can move it.

"Dave R." wrote:

Do you have a column next to "10-6161" that has a 4 in it?


"Crowraine" wrote in message
...
Ok, let me try this again.
I have 4 lipsticks which are represented in sheet 'Inventory Ordered'
cell
E3. I want those lipstick to be represented by 10-6161. Everytime I
type
in
10-6161 in sheet 'Inventory Sold' column B I want it to subtract from
'Inventory Ordered' cell E3 and the results to show in 'Inventory In
Stock'
cell D3.

Layout;
'Inventory Ordered' Cell E3 minus by part number 'Inventory Sold'
column B
to = in 'Inventory In Stock' D3

If I can't work it out, would someone also be kind enough to walk me
through
it once.

This is the formula I have.

=SUM(InventoryOrdered!E3,InventorySold!B:B)*COUNT( InventorySold!B:B,10-87400)

The count works by itself. But I can not get the count part to subtract from
the sum part. or heck, even add it at this point. At least then I would be
closer.

"Crowraine" wrote:

I do the COUNTIF but I want to subtract that from Sheet Inventory Ordered and
put the results in Sheet Inventory In Stock

"Dave R." wrote:

The confusion on my part was that you said you wanted 10-6161 to "be
represented by 4".

It sounds like you want to count all the 10-6161 in column B and subtract
that number from the "inventory ordered" amount.

You can use a formula like

=COUNTIF(B:B,"10-6161") to count up the 10-6161s in B. You can also
reference the cell that contains the part number like =COUNTIF(B:B,$A1).

If those do what you want, just include the COUNTIF... part in the formula
that you want to show your inventory (subtracting it from the number you
have ordered. if it's in the same row it should be easy).



"Crowraine" wrote in message
...
No. All the sheets, the part number is at least 3 columns over. But hey,
if I
need to I can move it.

"Dave R." wrote:

Do you have a column next to "10-6161" that has a 4 in it?


"Crowraine" wrote in message
...
Ok, let me try this again.
I have 4 lipsticks which are represented in sheet 'Inventory Ordered'
cell
E3. I want those lipstick to be represented by 10-6161. Everytime I
type
in
10-6161 in sheet 'Inventory Sold' column B I want it to subtract from
'Inventory Ordered' cell E3 and the results to show in 'Inventory In
Stock'
cell D3.

Layout;
'Inventory Ordered' Cell E3 minus by part number 'Inventory Sold'
column B
to = in 'Inventory In Stock' D3

If I can't work it out, would someone also be kind enough to walk me
through
it once.

New formula

=SUM(InventoryOrdered!E3,COUNT(InventorySold!B:B,1 0-87400))
Now how do I get it to subtract COUNT from Sum?

"Crowraine" wrote:

I do the COUNTIF but I want to subtract that from Sheet Inventory Ordered and
put the results in Sheet Inventory In Stock

"Dave R." wrote:

The confusion on my part was that you said you wanted 10-6161 to "be
represented by 4".

It sounds like you want to count all the 10-6161 in column B and subtract
that number from the "inventory ordered" amount.

You can use a formula like

=COUNTIF(B:B,"10-6161") to count up the 10-6161s in B. You can also
reference the cell that contains the part number like =COUNTIF(B:B,$A1).

If those do what you want, just include the COUNTIF... part in the formula
that you want to show your inventory (subtracting it from the number you
have ordered. if it's in the same row it should be easy).



"Crowraine" wrote in message
...
No. All the sheets, the part number is at least 3 columns over. But hey,
if I
need to I can move it.

"Dave R." wrote:

Do you have a column next to "10-6161" that has a 4 in it?


"Crowraine" wrote in message
...
Ok, let me try this again.
I have 4 lipsticks which are represented in sheet 'Inventory Ordered'
cell
E3. I want those lipstick to be represented by 10-6161. Everytime I
type
in
10-6161 in sheet 'Inventory Sold' column B I want it to subtract from
'Inventory Ordered' cell E3 and the results to show in 'Inventory In
Stock'
cell D3.

Layout;
'Inventory Ordered' Cell E3 minus by part number 'Inventory Sold'
column B
to = in 'Inventory In Stock' D3

If I can't work it out, would someone also be kind enough to walk me
through
it once.