Ask Me Help Desk

Ask Me Help Desk (https://www.askmehelpdesk.com/forum.php)
-   Spreadsheets (https://www.askmehelpdesk.com/forumdisplay.php?f=395)
-   -   Excel Formula needed (https://www.askmehelpdesk.com/showthread.php?t=5345)

  • Mar 18, 2003, 05:51 PM
    dotrain4u
    Excel Formula needed
    I am keeping an inventory in Excel. Let's say I start with 100 units of widgets, I take 20 widgets from the shelf, but return 10 wdgets later because I didn't use them. I need a formula that shows the 100, then I want to show that I took 20, and then have Excel show that I returned 10. Can anyone help with this?
  • Mar 22, 2003, 07:17 AM
    dtecmeister
    Excel Formula needed
    1. New excel sheet
    2. Sheet 1: 1st row: Balance | =SUM(Transactions!A:A)
    3. Sheet 2:
    100
    -20
    10
    Call sheet 1 Balance and sheet 2 Transactions.

    • All times are GMT -7. The time now is 12:22 AM.