Results 1 to 12 of 12

Needed...formula for fixed total....

Threaded View

Bembs21 Needed...formula for fixed... 05-11-2012, 09:59 AM
StevenM Re: Needed...formula for... 05-11-2012, 10:59 AM
Bembs21 Re: Needed...formula for... 05-11-2012, 11:23 AM
StevenM Re: Needed...formula for... 05-11-2012, 11:32 AM
Bembs21 Re: Needed...formula for... 05-11-2012, 11:35 AM
StevenM Re: Needed...formula for... 05-11-2012, 11:54 AM
Bembs21 Re: Needed...formula for... 05-11-2012, 12:44 PM
StevenM Re: Needed...formula for... 05-11-2012, 01:19 PM
Bembs21 Re: Needed...formula for... 05-11-2012, 01:47 PM
StevenM Re: Needed...formula for... 05-11-2012, 02:16 PM
Bembs21 Re: Needed...formula for... 05-14-2012, 07:27 AM
StevenM Re: Needed...formula for... 05-14-2012, 08:14 AM
  1. #1
    Registered User
    Join Date
    04-18-2012
    Location
    Ohio
    MS-Off Ver
    Excel 2007
    Posts
    6

    Needed...formula for fixed total....

    THIS IS AN INVENTORY SITUATION. I AM LOOKING TO HAVE A FIXED RUNNING TOTAL IN COLUMN "E" (QUANTITY ON HAND). i WANT TO ABLE TO CLEAR THE ADDED INFORMATION IN COLUMN "F" THROUGH "S" (SALES AND PO'S IN), BUT THE LAST TOTAL CALCULATED IN COLUMN "E" REMAIN, EVEN IF I CLEAR THE CELLS AND ADD NEW WHOLE NUMBERS. I WANT TO KEEP ADDING OR SUBTRACTING TO THE NUMBER ALREADY THERE IN COLUMN "E". THE FORMULA i HAVE NOW IS SIMPLE "SUM". IN COLUMN E TO SUBTRACT FROM THE COLUMN F-O ACROSS AND ADD FROM COLUMN S. WHICH WOULD WORK GREAT IF THE TOTAL IN COLUMN E STAYED WITH THE LAST NUMBER CALCULATED... I WANTED IT TO WORK LIKE THE YTD TOTALS...IF THIS MAKES ANY SENSE ...TO MAINTAIN THE VALUE OF QUANTITY ON HAND. ATTACHED IS MY FILE THAT I CREATED..GREATLY APPRECIATE ANY HELP....MAKE WHATEVER CHANGES NEED BE AND UPLOAD AGAIN...
    Attached Files Attached Files
    Last edited by Bembs21; 05-11-2012 at 01:06 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1