+ Reply to Thread
Results 1 to 4 of 4

Ignore Example Row in Excel Table

  1. #1
    Registered User
    Join Date
    05-11-2022
    Location
    Scotland
    MS-Off Ver
    MS Office 365
    Posts
    8

    Ignore Example Row in Excel Table

    Hi All! I have a table that will be going out to colleagues to complete. Unfortunately the table has a lot of columns and staff get confused. So in the top row I have put an example. The totals always include the example row or a sort of any column moves the example row away from the top. Is there anyway to get excel to completely ignore the top row? Example attached
    Attached Files Attached Files

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel (Windows 11 64-bit)
    Posts
    60,745

    Re: Ignore Example Row in Excel Table

    Try this:

    =SUBTOTAL(109,[Value])-C$2
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" to anyone who has offered you help in your thread. You can reward them by clicking on * Add Reputation below theur user name on the left, if you wish.


    Forum Rules (updated September 2018): please read them here.
    How to use the Power Query code you've been given: help here. More about the Power suite here.

  3. #3
    Registered User
    Join Date
    05-11-2022
    Location
    Scotland
    MS-Off Ver
    MS Office 365
    Posts
    8

    Re: Ignore Example Row in Excel Table

    That doesn't work as when I sort any column the value changes as the example line isn't staying at the top. I need it to stay at the top whether I sort any column A-Z AND sum total not to include the line

  4. #4
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    14,097

    Re: Ignore Example Row in Excel Table

    My suggestion may be too simplistic; however, could you put the Example row above the table which would allow sorting and yield the correct sum?
    Let us know if you have any questions.
    Attached Files Attached Files
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Sum only 1's in Pivot table and ignore other value
    By naveeddil in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 05-01-2019, 03:33 AM
  2. [SOLVED] Excel Line Chart: Ignore blanks in data and in pivot table
    By TMMc in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 11-07-2017, 03:07 PM
  3. Copy excel table to mail message but ignore cells with zero values
    By BOBMA in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-05-2016, 11:56 AM
  4. Ignore formulas in a table sort.
    By Mill8 in forum Excel General
    Replies: 3
    Last Post: 10-11-2016, 11:06 AM
  5. [SOLVED] How do I get a pivot table to ignore some values
    By Neostand in forum Excel General
    Replies: 3
    Last Post: 06-14-2006, 08:34 AM
  6. [SOLVED] Ignore 0 in pivot table
    By Johan in forum Excel General
    Replies: 0
    Last Post: 04-04-2005, 04:06 PM
  7. [SOLVED] Pivot Table to Ignore N/As
    By Nelson in forum Excel General
    Replies: 2
    Last Post: 02-16-2005, 08:39 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