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.