Results 1 to 2 of 2

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

Threaded View

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

    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

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