Results 1 to 10 of 10

Sum if 5 consecutive numbers are> 1

Threaded View

  1. #1
    Forum Contributor
    Join Date
    05-16-2012
    Location
    Latina, ITALY
    MS-Off Ver
    Excel 2010--2016
    Posts
    947

    Sum if 5 consecutive numbers are> 1

    Good morning I would need a formula to check if there are 5 consecutive numbers >1 and add them.

    In case there were 2 sequences of 5 numbers > 1 add the one with the highest value.

    In the case of column E the consecutive numbers >1 are 7 and we must see which combination gives the largest value as in the example F16: H20

    The result entered by hand is in G2: J2
    Thank you
    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. Replies: 3
    Last Post: 09-15-2017, 05:30 AM
  2. Consecutive numbers
    By newx in forum Excel General
    Replies: 8
    Last Post: 09-08-2015, 09:04 PM
  3. Finding 5 consecutive numbers in a set of 7 numbers
    By Namejs in forum Excel General
    Replies: 13
    Last Post: 05-20-2015, 06:35 AM
  4. How to get MIN and MAX of Consecutive Numbers
    By Livmi in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 05-12-2015, 02:04 PM
  5. Replies: 6
    Last Post: 03-23-2012, 06:03 PM
  6. Sum Non-consecutive Numbers
    By dschwister in forum Excel General
    Replies: 12
    Last Post: 10-13-2011, 06:08 PM
  7. Excel macro to "fill in" consecutive numbers in non-consecutive list?
    By Tomkat in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-03-2009, 01:13 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