Closed Thread
Results 1 to 2 of 2

Sum and CountIF with table elements

  1. #1
    Forum Contributor
    Join Date
    09-17-2014
    Location
    UK
    MS-Off Ver
    2007
    Posts
    117

    Sum and CountIF with table elements

    I want to delete rows in a table where cells after column E (listcolumns(5)) are blank.

    Initially I used the following:
    Please Login or Register  to view this content.
    However it fails if there are positive and negative values that cancel each other out as this data needs to remain. It also wasn't addressing the table but that's something I'm going to sort shortly.

    So I need to change from a Sum to a CountIF however the following does not work (argument not optional):
    Please Login or Register  to view this content.
    This did not give any error but rsum always has a value of empty:
    Please Login or Register  to view this content.
    I could loop through each Listrow to determine if all cells are blank but this wouldn't be efficient.

    Can anyone advise what I've missed/done incorrectly?

  2. #2
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,532

    Re: Sum and CountIF with table elements

    Welcome to the Forum, unfortunately:

    This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

    Thread Closed.
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

Closed Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Sum and CountIF with table elements
    By BuZZarD73 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-24-2015, 11:32 AM
  2. [SOLVED] Deleteing elements in a table quickly
    By Zealotwraith in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-26-2013, 12:52 PM
  3. Resources for Using VBA to Manipulate Silverlight Elements like HTML Elements
    By linear_db in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-16-2013, 04:43 PM
  4. [SOLVED] Complex countif of array elements
    By Biff in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-09-2006, 04:55 PM
  5. Make a list from a table of elements ?
    By Lucy Lastic in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-08-2005, 09:10 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