Results 1 to 19 of 19

Ignore blank cells

Threaded View

Zagra147 Ignore blank cells 03-01-2014, 01:33 PM
popipipo Re: Ignore blank cells 03-01-2014, 01:41 PM
Zagra147 Re: Ignore blank cells 03-01-2014, 02:04 PM
Zagra147 Re: Ignore blank cells 03-01-2014, 02:42 PM
Zagra147 Re: Ignore blank cells 03-01-2014, 02:45 PM
Zagra147 Re: Ignore blank cells 03-01-2014, 02:55 PM
Winon Re: Ignore blank cells 03-01-2014, 02:22 PM
AlKey Re: Ignore blank cells 03-01-2014, 02:28 PM
Zagra147 Re: Ignore blank cells 03-01-2014, 02:41 PM
AlKey Re: Ignore blank cells 03-01-2014, 02:43 PM
icestationzbra Re: Ignore blank cells 03-01-2014, 02:44 PM
Winon Re: Ignore blank cells 03-01-2014, 02:50 PM
Zagra147 Re: Ignore blank cells 03-01-2014, 03:00 PM
Winon Re: Ignore blank cells 03-01-2014, 02:57 PM
Winon Re: Ignore blank cells 03-01-2014, 03:02 PM
Zagra147 Re: Ignore blank cells 03-01-2014, 03:23 PM
Zagra147 Re: Ignore blank cells 03-01-2014, 03:18 PM
Winon Re: Ignore blank cells 03-01-2014, 03:25 PM
Winon Re: Ignore blank cells 03-01-2014, 03:32 PM
  1. #1
    Forum Contributor
    Join Date
    10-10-2006
    Location
    Birmingham UK
    MS-Off Ver
    Excel 2019, Win 10
    Posts
    102

    Ignore blank cells

    I have a row of cells, say, A1 to G1.
    I wish to sum the values in cells, say, A1, C1, F1 and G1 only. The chosen cells can have values 0, >0 or Blank. How do I sum the values and ignore the blank cell(s) without getting #VALUE!?
    Filling the blank cells with "0" is not an option.

    (Any blank cells may have a value added at a later date).

    Edit: I could use multiple 'IF' statements, but this is cumbersome. There must be a simpler way.

    Thanks in advance

    Alan
    Last edited by Zagra147; 03-01-2014 at 02:20 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Ignore blank cells and truly blank cells in named range?
    By hschillig in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 01-13-2014, 02:56 PM
  2. How can I make a macro ignore blank cells? - Blank Cells have formulas
    By mz1161 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-30-2013, 08:54 AM
  3. Ignore blank cells
    By Teacher in forum Excel General
    Replies: 13
    Last Post: 08-20-2011, 03:43 PM
  4. How To ignore blank cells....
    By gtdi-95 in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 01-15-2008, 06:03 AM
  5. [SOLVED] how do you ignore blank cells
    By Kerry in forum Excel General
    Replies: 1
    Last Post: 02-16-2005, 10:42 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