+ Reply to Thread
Results 1 to 3 of 3

Subtracting from different cells

  1. #1
    Forum Contributor
    Join Date
    04-09-2010
    Location
    Fort Myers, FL
    MS-Off Ver
    Excel for MAC
    Posts
    146

    Subtracting from different cells

    Hello,

    I am tryig to figure out how to make F2 the total tach time. The tach started at 58.6 (C2), and everyday the tach time goes up, so it's an ever changing cell to subtract from. How do I make F2 the total tach time? F2 should read 22.9 right now... (basically SUM(F5:F17) ) but the -81.5 always changes...

    Thanks in advance!

    Screen Shot 2014-04-22 at 3.46.20 PM.jpg

    Okay here is the spreadsheet: 528MW.xlsx
    Last edited by nkitchen31; 04-22-2014 at 04:00 PM.

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2407 Win 11 Home 64 Bit
    Posts
    24,073

    Re: Subtracting from different cells

    Picture:

    Hi and welcome to the forum

    Please do not upload a picture of your file...rather, upload a sample of your workbook, showing what data you are working with, a few samples of your expected outcome (manually entered is ok) and how you arrived at that. (Exclude sensitive info). Pictures are pretty much impossible to edit, and no-one wants to re-type your data for you. Also, not all members can upload picture files (Company firewalls, etc.)

    To attach a file to your post,
    click advanced (next to quick post),
    scroll down until you see "manage file",
    click that and select "add files" (top right corner).
    click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"

    Once the upload is completed the file name will appear below the input boxes in this window.
    You can then close the window to return to the new post screen.
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

  3. #3
    Forum Contributor
    Join Date
    04-09-2010
    Location
    Fort Myers, FL
    MS-Off Ver
    Excel for MAC
    Posts
    146

    Re: Subtracting from different cells

    Nevermind... Solved with =MAX(0 formula on the entire F column.

    Thank you.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 0
    Last Post: 05-08-2012, 12:42 PM
  2. Subtracting Numbers in Cells
    By gloom52 in forum Excel - New Users/Basics
    Replies: 6
    Last Post: 09-10-2009, 01:15 PM
  3. Subtracting cells
    By rkaiser in forum Excel General
    Replies: 3
    Last Post: 04-20-2007, 12:21 PM
  4. Subtracting From 2 Cells
    By scw1217 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 04-04-2006, 08:56 PM
  5. Subtracting 2 Now() Cells
    By rich in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 02-08-2006, 04:15 PM

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