+ Reply to Thread
Results 1 to 2 of 2

write a multi-column formula for an inventory spreadsheet

  1. 01-19-2008, 05:23 PM #1
    r.m.m.
    r.m.m. is offline
    Registered User
    Join Date
    01-19-2008
    Posts
    1

    write a multi-column formula for an inventory spreadsheet

    I need to create a formula that will allow entering quantities in columns A, B, and C that will automatically be subtracted from an EXISTING inventory quantity in column D. This formula needs to be applied to 165 existing rows of products. Can anyone tell me how to do this?
    Many thanks!
    Reply With QuoteRegister To Reply
  2. 01-19-2008, 06:18 PM #2
    protonLeah
    protonLeah is offline
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    12,625
    In general, say that column E is available, then in En:
    =Dn-SUM(An:Cn)
    or,
    =Dn-An-Bn-Cn
    Where n is the first row to be computed.
    Ben Van Johnson
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1