+ Reply to Thread
Results 1 to 6 of 6

Identifying hidden rows to exclude from sumifs

Hybrid View

Cbird Identifying hidden rows to... 11-28-2017, 04:52 PM
leelnich Re: Identifying hidden rows... 11-28-2017, 05:17 PM
Cbird Re: Identifying hidden rows... 11-28-2017, 11:14 PM
leelnich Re: Identifying hidden rows... 11-28-2017, 11:47 PM
Cbird Re: Identifying hidden rows... 11-29-2017, 12:10 AM
leelnich Re: Identifying hidden rows... 11-29-2017, 12:24 AM
  1. 11-28-2017, 11:47 PM #1
    leelnich is offline
    Forum Expert leelnich's Avatar
    Join Date
    03-20-2017
    Location
    Delaware, USA
    MS-Off Ver
    Office 2016
    Posts
    2,807

    Re: Identifying hidden rows to exclude from sumifs

    Is there a value in column A for that row? SUBTOTAL(103..) mimics COUNTA, so it returns 0 if A is blank. Also, make sure calculation is set to automatic.
    Last edited by leelnich; 11-28-2017 at 11:50 PM.
    Clicking the Add Reputation star below helpful posts is a great way to show your appreciation.
    Please mark your threads as SOLVED upon conclusion (Thread Tools above Post # 1). - Lee
    Reply With QuoteRegister To Reply
  2. 11-29-2017, 12:10 AM #2
    Cbird is offline
    Registered User
    Join Date
    10-24-2017
    Location
    Omaha, NE
    MS-Off Ver
    Excel 2010
    Posts
    25

    Re: Identifying hidden rows to exclude from sumifs

    Thank you!
    That was my issue.
    Works perfectly now.
    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. SUMIFS to exclude a value
    By Motox in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 11-21-2016, 12:51 AM
  2. SUMIFS and exclude Duplicates
    By Mark929 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 09-01-2015, 01:06 PM
  3. Exclude cells in SUM if they are hidden?
    By horsefish01 in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 06-02-2015, 07:33 PM
  4. Sumifs exclude cells that are hidden with data filter
    By rhyan66 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 12-18-2013, 10:16 AM
  5. PivotTable Exclude hidden rows
    By Mambaout626 in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 12-03-2013, 12:32 AM
  6. How to exclude hidden rows while running a code?
    By heena.singh in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 06-19-2013, 06:25 AM
  7. Exclude Rows that are hidden from SUM
    By markdc01 in forum Excel General
    Replies: 8
    Last Post: 01-21-2007, 05:12 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