Results 1 to 10 of 10

Change formula that removes blank cells to also exclude certain text from output list.

Threaded View

  1. #1
    Forum Contributor Big.Moe's Avatar
    Join Date
    03-15-2012
    Location
    Corea, Maine, USA
    MS-Off Ver
    Excel 2010
    Posts
    244

    Change formula that removes blank cells to also exclude certain text from output list.

    In the attached file (starting @ G470), I'm using the following formula to create a 'summation' of daily sales without all the blank cells:
    Formula: copy to clipboard
    =IFERROR(INDEX($G$40:$G$466,SMALL((IF(LEN($G$40:$G$466),ROW(INDIRECT("1:"&ROWS($G$40:$G$466))))),ROW(G1)),1),"")

    Everything works great except for, due to print-out formatting, I had to insert the column headers at each print page break, and hence the header text gets picked-up by the formula and gets included in the list. Is there a way to append this formula to exclude these headers?
    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. Exclude blank cells from COUNTIFS formula
    By Leahsco in forum Excel Formulas & Functions
    Replies: 13
    Last Post: 08-05-2014, 11:45 AM
  2. [SOLVED] Formula SUM - exclude cells with text / value problem
    By renix in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 02-04-2014, 09:48 AM
  3. Replies: 5
    Last Post: 05-09-2013, 01:16 AM
  4. Getting Rank formula to exclude zero and blank cells
    By Catherine01 in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 04-11-2013, 06:10 AM
  5. Exclude blank/FALSE cells in in Excel array IF formula output
    By sushix in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 03-08-2013, 11:42 AM
  6. (SOLVED) Drop down list removes used cells
    By SubwAy in forum Excel General
    Replies: 5
    Last Post: 10-22-2011, 01:56 PM
  7. How to delete cells having formula with blank output?
    By Damongz in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-12-2011, 03: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