Excel/excel inventory

Advertisement


Question
so i have a formula, =COUNTIF(A:A,"grey")-COUNTIF(A:A,"grey-1") that will give me a number of the amount of tshirts that i have sold, or added, to my inventory. if i only sell shirts, i will have some negative number, if i got new ones in, i will have a positive number. it just counts the total number of shirts coming and going out for the day, lets say that number is in A1 and the number for today is -3, reflecting that i have sold 3 shirts. well i have the number of shirts i started with that morning, lets say 10, in column B1. i need for B1 to update its value by getting the sum from A1 and itself. is there a way to do that? now i can use a copy of my original spreadsheet to configure the new totals and all of that, but i need the master sheet to be updated using the numbers from the copy. i only sell 12 different tshirts with different sizes but i sell alot, as well as acquire new inventory, so i like to use this method because it allows me to use my barcode scanner. is there any way to get the cells to update their numbers from another sheet without the "=" operator? the = operator will not work because i wouldnt have a number to reference for calculations. help please.

Answer
I'm not 100% sure I understand the question, but it SOUNDS as though you want to store a value by updating a single cell without using a formula?  IF so, the only way to automatically do this would be via VBA (i.e a macro) - it may be clearer if I saw a sample file however - my direct email is support@flameenterprises.co.uk - it's also not clear what data you already hold, so if (for example) you are storing the date of the transaction, that could be used with a formula to determine the previous days stock level.
About Excel
This topic answers questions related to Microsoft Excel spreadsheet (or workbook) stand-alone or Mircrosoft Office Excel including Excel 2003, Excel 2007, Office 2000, and Office XP. You can get Excel help on Excel formulas(or functions), Excell macros, charting in Excel, advanced features, and the general use of Excel. This does not provide a general Excel tutorial nor the basics of using a spreadsheet. It provides specific answers to using Microsoft Excel only. If you do not see your Excel question answered in this area then please ask an Excel question here

Excel

All Answers


Answers by Expert:


Ask Experts

Volunteer


Aidan Heritage

Expertise

I have provided first hand support since `95 for Microsoft Office majoring in Word and Excel - support for all versions from 2 onwards. I'm based in the UK, so please allow for time differences when asking me questions from other parts of the world!

Experience

My background is in the insurance industry and call centre areas, but have been called upon to provide many varied solutions.

Education/Credentials
I'm educated to UK A level standard, but as I left school some 30 years ago that is rather irrelevent - university of life has provided more of a background!

©2016 About.com. All rights reserved.