Formulas - Excel
 

Here's a brief on my situation. I'm selling some t-shirts I created. I have
both black and white versions of the shirt I wanted to be able to use MS
Excel to log my sales (Sheet 1) and possibly track inventory (Sheet 2).

I was going to use an "IF" formula, but it doesn't seem to work to well for
what I want to be done. For instance, I have 10 Medium Black T-Shirts and 10
Medium White T-Shirts. If I sell a single T-Shirt that is black and a medium
size, I want the program to automatically deduct from my quantity of 10 to
show that I have 9 remaining (or show a quantity of 1 in a below cell and
I'll subtract it to get a total of 9 remaining). Likewise, I'd like to be
able to have white tshirt sales and black tshirt sales on the same log.

I'm stuck and believe it can be done in Excel, but I cannot think about this
properly and make it functional. I've spent some hours trying to figure this
out, but don't know the answer.

Hence, there are multiple questions: What's the easiest way to accomplish
this feat? Should I use Excel? Should I use Access? Should I use both? If
it is possible to do in excel, what's the best way to make it happen?

BTW: I'm a much more advance user of Excel than Access, but I just want to
know which is better/simplest.

Formulas - Excel
 

You can use SUMIF on Sheet2 to sum number of items sold by type on Sheet1.
You can subtract that from the total to get the availability.

You can use VLOOKUP from sheet1 to sheet2 to lookup the availability for any
given type which you can have in a dropdown...

"Donovan" wrote:

Here's a brief on my situation. I'm selling some t-shirts I created. I have
both black and white versions of the shirt I wanted to be able to use MS
Excel to log my sales (Sheet 1) and possibly track inventory (Sheet 2).

I was going to use an "IF" formula, but it doesn't seem to work to well for
what I want to be done. For instance, I have 10 Medium Black T-Shirts and 10
Medium White T-Shirts. If I sell a single T-Shirt that is black and a medium
size, I want the program to automatically deduct from my quantity of 10 to
show that I have 9 remaining (or show a quantity of 1 in a below cell and
I'll subtract it to get a total of 9 remaining). Likewise, I'd like to be
able to have white tshirt sales and black tshirt sales on the same log.

I'm stuck and believe it can be done in Excel, but I cannot think about this
properly and make it functional. I've spent some hours trying to figure this
out, but don't know the answer.

Hence, there are multiple questions: What's the easiest way to accomplish
this feat? Should I use Excel? Should I use Access? Should I use both? If
it is possible to do in excel, what's the best way to make it happen?

BTW: I'm a much more advance user of Excel than Access, but I just want to
know which is better/simplest.

Formulas - Excel
 

Sheeloo,

Thanks for the SUMIF, I didn't think of that. Nevertheless, I believe it's
more complicated than that. It's quite possible I didn't accurately detail
it in my original post. I've emailed you the spreadsheet for further
clarity. Feel free to post here so others may learn if applicable.

-Donovan

"Sheeloo" wrote:

You can use SUMIF on Sheet2 to sum number of items sold by type on Sheet1.
You can subtract that from the total to get the availability.

You can use VLOOKUP from sheet1 to sheet2 to lookup the availability for any
given type which you can have in a dropdown...

"Donovan" wrote:

Here's a brief on my situation. I'm selling some t-shirts I created. I have
both black and white versions of the shirt I wanted to be able to use MS
Excel to log my sales (Sheet 1) and possibly track inventory (Sheet 2).

I was going to use an "IF" formula, but it doesn't seem to work to well for
what I want to be done. For instance, I have 10 Medium Black T-Shirts and 10
Medium White T-Shirts. If I sell a single T-Shirt that is black and a medium
size, I want the program to automatically deduct from my quantity of 10 to
show that I have 9 remaining (or show a quantity of 1 in a below cell and
I'll subtract it to get a total of 9 remaining). Likewise, I'd like to be
able to have white tshirt sales and black tshirt sales on the same log.

I'm stuck and believe it can be done in Excel, but I cannot think about this
properly and make it functional. I've spent some hours trying to figure this
out, but don't know the answer.

Hence, there are multiple questions: What's the easiest way to accomplish
this feat? Should I use Excel? Should I use Access? Should I use both? If
it is possible to do in excel, what's the best way to make it happen?

BTW: I'm a much more advance user of Excel than Access, but I just want to
know which is better/simplest.

Formulas - Excel
 

I did not get the mail. Try sending it again or upload the file to
wikisend.com and paste the link here... (after removing any confidential data)

"Donovan" wrote:

Sheeloo,

Thanks for the SUMIF, I didn't think of that. Nevertheless, I believe it's
more complicated than that. It's quite possible I didn't accurately detail
it in my original post. I've emailed you the spreadsheet for further
clarity. Feel free to post here so others may learn if applicable.

-Donovan

"Sheeloo" wrote:

You can use SUMIF on Sheet2 to sum number of items sold by type on Sheet1.
You can subtract that from the total to get the availability.

You can use VLOOKUP from sheet1 to sheet2 to lookup the availability for any
given type which you can have in a dropdown...

"Donovan" wrote:

Here's a brief on my situation. I'm selling some t-shirts I created. I have
both black and white versions of the shirt I wanted to be able to use MS
Excel to log my sales (Sheet 1) and possibly track inventory (Sheet 2).

I was going to use an "IF" formula, but it doesn't seem to work to well for
what I want to be done. For instance, I have 10 Medium Black T-Shirts and 10
Medium White T-Shirts. If I sell a single T-Shirt that is black and a medium
size, I want the program to automatically deduct from my quantity of 10 to
show that I have 9 remaining (or show a quantity of 1 in a below cell and
I'll subtract it to get a total of 9 remaining). Likewise, I'd like to be
able to have white tshirt sales and black tshirt sales on the same log.

I'm stuck and believe it can be done in Excel, but I cannot think about this
properly and make it functional. I've spent some hours trying to figure this
out, but don't know the answer.

Hence, there are multiple questions: What's the easiest way to accomplish
this feat? Should I use Excel? Should I use Access? Should I use both? If
it is possible to do in excel, what's the best way to make it happen?

BTW: I'm a much more advance user of Excel than Access, but I just want to
know which is better/simplest.

Formulas - Excel
 

I've sent it again...
I think I put the wrong address initially.

it should come from redeemedfashions<atyahoo<dotcom

If you still don't get it, I may be able to upload it later today

"Sheeloo" wrote:

I did not get the mail. Try sending it again or upload the file to
wikisend.com and paste the link here... (after removing any confidential data)

"Donovan" wrote:

Sheeloo,

Thanks for the SUMIF, I didn't think of that. Nevertheless, I believe it's
more complicated than that. It's quite possible I didn't accurately detail
it in my original post. I've emailed you the spreadsheet for further
clarity. Feel free to post here so others may learn if applicable.

-Donovan

"Sheeloo" wrote:

You can use SUMIF on Sheet2 to sum number of items sold by type on Sheet1.
You can subtract that from the total to get the availability.

You can use VLOOKUP from sheet1 to sheet2 to lookup the availability for any
given type which you can have in a dropdown...

"Donovan" wrote:

Here's a brief on my situation. I'm selling some t-shirts I created. I have
both black and white versions of the shirt I wanted to be able to use MS
Excel to log my sales (Sheet 1) and possibly track inventory (Sheet 2).

I was going to use an "IF" formula, but it doesn't seem to work to well for
what I want to be done. For instance, I have 10 Medium Black T-Shirts and 10
Medium White T-Shirts. If I sell a single T-Shirt that is black and a medium
size, I want the program to automatically deduct from my quantity of 10 to
show that I have 9 remaining (or show a quantity of 1 in a below cell and
I'll subtract it to get a total of 9 remaining). Likewise, I'd like to be
able to have white tshirt sales and black tshirt sales on the same log.

I'm stuck and believe it can be done in Excel, but I cannot think about this
properly and make it functional. I've spent some hours trying to figure this
out, but don't know the answer.

Hence, there are multiple questions: What's the easiest way to accomplish
this feat? Should I use Excel? Should I use Access? Should I use both? If
it is possible to do in excel, what's the best way to make it happen?

BTW: I'm a much more advance user of Excel than Access, but I just want to
know which is better/simplest.