+ Reply to Thread
Results 1 to 8 of 8

Count of Consecutive Zeros excluding #N/A

Hybrid View

  1. 07-09-2014, 03:31 AM #1
    kvsrinivasamurthy
    kvsrinivasamurthy is offline
    Forum Expert
    Join Date
    07-20-2011
    Location
    Mysore, India.
    MS-Off Ver
    Excel 2019
    Posts
    8,710

    Re: Count of Consecutive Zeros excluding #N/A

    Pl see attached file. Helper column is used.
    Attached Files Attached Files
    Last edited by kvsrinivasamurthy; 07-09-2014 at 04:08 AM.
    Reply With QuoteRegister To Reply
  2. 07-09-2014, 09:12 PM #2
    gaffee
    gaffee is offline
    Registered User
    Join Date
    07-08-2014
    Location
    Brisbane, Australia
    MS-Off Ver
    2013
    Posts
    3

    Re: Count of Consecutive Zeros excluding #N/A

    Thank you so much for your help!!
    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. Count Consecutive 0 starting from the Last non zero cell in a row (excluding blanks)
    By Intalzky in forum Excel Formulas & Functions
    Replies: 20
    Last Post: 05-02-2014, 06:42 AM
  2. Excluding zeros from count
    By ihosey in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 01-31-2014, 09:40 AM
  3. Count longest consecutive run of zeros
    By TheRobsterUK in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-17-2013, 08:02 AM
  4. [SOLVED] Average for non-consecutive cells excluding zeros (even when they all contain zeros)
    By pao13 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 11-05-2012, 04:32 PM
  5. [SOLVED] Average, Excluding Zeros, Non-Consecutive Range
    By Coal Miner in forum Excel General
    Replies: 9
    Last Post: 08-04-2005, 06:05 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1