Results 1 to 6 of 6

Disregard empty cells

Threaded View

  1. #1
    Registered User
    Join Date
    09-19-2016
    Location
    Sussex, England
    MS-Off Ver
    10
    Posts
    5

    Disregard empty cells

    The attached sheet shows a league table for a simple competition run over 20 or so weeks for 12 teams and with a quirky scoring system. The problem I have is recording the total number of tied games accumulated by the teams (tied games being worth one league point). Having laid out the fixtures for the entire season the formula at cell H4:M4 effectively counts the empty cells in columns C&D for future games as being tied by virtue of null value equaling null value or whatever. Yes I could write or copy and paste the fixtures but having come this far..... What can I add/create to solve the empty cell problem? TIA
    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. Getting SUMIFS to disregard cells that are blank
    By NDmad in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-28-2016, 01:21 PM
  2. [SOLVED] 8 Columns with empty cells -> 1 Column without empty cells -> Problem: 1st value ignored
    By chrisignm in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 09-23-2015, 04:50 AM
  3. [SOLVED] excel 2010 empty a cell according to other cells (without Deleting them just show empty)
    By pavlos_x in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-11-2015, 01:46 PM
  4. [SOLVED] Disregard or skip blank cells
    By sunjam in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-17-2014, 01:47 AM
  5. Change Print Area to Disregard Blank Cells
    By misty0705 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-22-2008, 01:25 AM
  6. Disregard empty cells?
    By Tyke in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 04-13-2007, 01:33 PM
  7. macro to colour empty cells (cells not recognized as empty)
    By Gerben in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 06-30-2005, 11:05 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