+ Reply to Thread
Results 1 to 6 of 6

Find and sum of the most consecutive positive numbers in a column A

  1. 06-09-2021, 08:22 PM #1
    rayhen
    rayhen is offline
    Forum Contributor
    Join Date
    09-01-2020
    Location
    bangladesh
    MS-Off Ver
    office 2007
    Posts
    170

    Find and sum of the most consecutive positive numbers in a column A

    Dear forum experts

    The maximum consecutive number does not contain 0 and blank

    cell C2 is the final result

    Thanks for any help !
    Attached Files Attached Files
    Last edited by rayhen; 06-09-2021 at 10:43 PM.
    Reply With QuoteRegister To Reply
  2. 06-09-2021, 10:35 PM #2
    NickyC
    NickyC is offline
    Forum Expert
    Join Date
    06-09-2010
    Location
    Australia
    MS-Off Ver
    Excel 2013
    Posts
    1,714

    Re: Find and sum of the most consecutive positive numbers in a column A

    Hi
    it's a bit clunky but this user-defined function seems to work

    Please Login or Register  to view this content.
    type

    Formula: copy to clipboard 
    Please Login or Register  to view this content.


    into any cell to return the sum of the most consecutive positive values
    Reply With QuoteRegister To Reply
  3. 06-09-2021, 10:42 PM #3
    rayhen
    rayhen is offline
    Forum Contributor
    Join Date
    09-01-2020
    Location
    bangladesh
    MS-Off Ver
    office 2007
    Posts
    170

    Re: Find and sum of the most consecutive positive numbers in a column A

    Excellent solution. Thank you @NickyC ; thank you very much for the solution.
    Reply With QuoteRegister To Reply
  4. 06-10-2021, 03:24 AM #4
    wk9128
    wk9128 is offline
    Forum Expert wk9128's Avatar
    Join Date
    08-15-2020
    Location
    China Shanghai
    MS-Off Ver
    365 V2502 and WPS V2024(12.1.0.18543)
    Posts
    3,842

    Re: Find and sum of the most consecutive positive numbers in a column A

    cell C2 array formula

    HTML Code: 
    Reply With QuoteRegister To Reply
  5. 06-10-2021, 06:04 AM #5
    rayhen
    rayhen is offline
    Forum Contributor
    Join Date
    09-01-2020
    Location
    bangladesh
    MS-Off Ver
    office 2007
    Posts
    170

    Re: Find and sum of the most consecutive positive numbers in a column A

    I didn't expect that the formula can also be solved, thank you so much @wk9128 , you always surprise me too much
    Reply With QuoteRegister To Reply
  6. 06-11-2021, 09:36 AM #6
    wk9128
    wk9128 is offline
    Forum Expert wk9128's Avatar
    Join Date
    08-15-2020
    Location
    China Shanghai
    MS-Off Ver
    365 V2502 and WPS V2024(12.1.0.18543)
    Posts
    3,842

    Re: Find and sum of the most consecutive positive numbers in a column A

    You're Welcome. Thank You for the feedback
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Find the cell reference of consecutive largest negative/positive numbers
    By atif mehmood satti in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 06-09-2021, 06:56 AM
  2. Counting how many consecutive negative or positive numbers in column.
    By Smedlex in forum Excel General
    Replies: 1
    Last Post: 04-14-2015, 08:34 PM
  3. [SOLVED] Find consecutive 15 positive or negative numbers in a column
    By Sarangsood in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 11-19-2013, 05:26 AM
  4. [SOLVED] Count Consecutive Positive/Negative numbers
    By Taislin in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-16-2013, 01:02 PM
  5. consecutive positive numbers
    By jmoore1197 in forum Excel General
    Replies: 25
    Last Post: 07-19-2012, 07:54 AM
  6. Count number of instances in which two consecutive numbers in a column are positive
    By DavidHD in forum Excel General
    Replies: 5
    Last Post: 09-01-2011, 03:46 AM
  7. how to add consecutive positive numbers
    By shreen_farhad in forum Excel General
    Replies: 1
    Last Post: 10-02-2005, 02:51 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1