Results 1 to 4 of 4

Formula Help - Counting Blank Cells and Counting Number of Cells Since the Last Blank Cell

Threaded View

bubaseballfan Formula Help - Counting Blank... 08-30-2018, 03:29 PM
avk Re: Formula Help - Counting... 08-30-2018, 03:46 PM
bubaseballfan Re: Formula Help - Counting... 08-30-2018, 04:22 PM
FlameRetired Re: Formula Help - Counting... 08-30-2018, 11:13 PM
  1. #1
    Registered User
    Join Date
    08-30-2018
    Location
    Texas
    MS-Off Ver
    Office 2016
    Posts
    2

    Formula Help - Counting Blank Cells and Counting Number of Cells Since the Last Blank Cell

    I have a table with 8 items that we sell. Each item has a code, which corresponds to the applicable pricing sale we have for that item, over a span of 8 time periods.

    I'm having trouble coming up with efficient formulas that will give me the answers that are in the orange-colored boxes.

    pic2.PNG

    This table has been simplified -- the true table I need formulas for has hundreds of various codes, and hundreds of periods, so simply doing a 8-step nested "if" statement won't really cut it in this particular project.

    I've attached the workbook so you can play around in it. The values in orange are the correct values, and are the cells I need formulas for.

    I appreciate any help I can get.
    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. Counting blank cells up to first non-blank cell
    By DLG3 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 12-08-2015, 07:36 AM
  2. Ignore blank cells in formula counting number of different cells.
    By deneh in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 07-07-2015, 08:52 AM
  3. [SOLVED] repeat counting of blank cells till a cell with number/text
    By joshcct in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-03-2015, 03:33 AM
  4. [SOLVED] Counting number of non blank cells and inserting that amount on another sheet
    By cheeze83 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 09-20-2013, 05:39 AM
  5. counting the number of instances of blank cells in a range
    By moses67 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-01-2013, 10:35 AM
  6. Counting number of non-blank cells for every nth cell
    By mqp92 in forum Excel Formulas & Functions
    Replies: 14
    Last Post: 02-03-2013, 11:08 AM
  7. [SOLVED] Counting number of non-blank cells in column......but getting run time error in vba
    By welchs101 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-30-2012, 10:54 AM

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