+ Reply to Thread
Results 1 to 2 of 2

Adding a series of differences from a list, negatives must be counted as positive too

  1. #1
    Registered User
    Join Date
    05-15-2021
    Location
    Ireland
    MS-Off Ver
    2021
    Posts
    16

    Adding a series of differences from a list, negatives must be counted as positive too

    Hi, strange question, I want to ask about adding numbers....

    I've attached the images of graphs for visual aid. I'm trying to figure out a way to do what I've done n the photo. So as you can see, there are two graphs, both have a 'best fit' line that shows a 20% increase. Graph 2 looks like a walk through the park with n up/down total of 6. Graph 1 look like something that would make Tolkien proud, has gone on a big adventure and gathered an up/down total of 42. So were, weather its positive or negative, all movement is calculated as a positive integer.

    I've a spreadsheet attached (its what I took the spreadsheet image from) and its a simple list of numbers (as seen below).

    Does anyone know how I can get my up/down total from a list like this?

    I can figure out a work-around using a few different steps but the best I can come up with is something very convoluted. I'll be doing this with 4 lists, each with 60 entries each constantly fluctuating every minute. (I'm calculating real-time data) so the less steps the better.

    Any advice is well appreciated! Thanks in advance!!!
    Attached Images Attached Images
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor
    Join Date
    03-24-2020
    Location
    Thailand
    MS-Off Ver
    Office 2016
    Posts
    494

    Re: Adding a series of differences from a list, negatives must be counted as positive too

    Hi there,

    For graph 1 try in cell L2:
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    Basically calculating the difference between each T column as a positive number...
    If your Question is answered; please mark it SOLVED. If you are happy with a member's solution, say 'Thanks' and click the 'Star' to Add Reputation.

+ 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. Match Positive and Negatives then Highlight
    By werko in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 06-07-2014, 04:43 PM
  2. Find negatives and reciprocal positive values to flag
    By phil3061 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-30-2013, 04:00 PM
  3. [SOLVED] Adding Positive and Negatives
    By Jflann1 in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 08-18-2012, 04:23 PM
  4. Evaluating cell values for corresponding positive and negatives
    By rwmccall in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-13-2011, 10:59 PM
  5. Sum Negatives into next Positive
    By ScooterNM5 in forum Excel Programming / VBA / Macros
    Replies: 16
    Last Post: 11-05-2010, 07:01 AM
  6. Converting inputted negatives to positive #'s
    By JMRamsey in forum Excel General
    Replies: 4
    Last Post: 06-14-2007, 04:00 PM
  7. I need to change positive values to negatives
    By lancekeith in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-05-2006, 02:32 PM

Tags for this Thread

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