Results 1 to 4 of 4

Help with formula using different rows and columns

Threaded View

  1. #1
    Registered User
    Join Date
    04-22-2014
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    2

    Help with formula using different rows and columns

    I have this formula I am trying to paste into my spreadsheet, ex. =80000-SUM(D2,C3). But everytime I paste it in, it shows up =80000-SUM(E2,D3) and then I have to change it back to C3. How do I get the formula to work so that it only uses my Weight Column and Row without having to manually change the formula? I attached a picture that will hopefully help explain better than I have.

    excel.jpg
    Attached Images Attached Images

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 15
    Last Post: 12-06-2012, 01:07 PM
  2. Increment columns in INDEX and MATCH formula - ROWS and COLUMNS
    By nickmangan in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2012, 10:38 AM
  3. Categorizing rows/columns for formula use
    By kelson49er in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 05-27-2010, 12:09 PM
  4. A formula to transpose rows into columns?
    By money n da sank in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 07-17-2008, 11:58 AM
  5. Replies: 0
    Last Post: 11-28-2007, 06:46 AM

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