Results 1 to 13 of 13

Why does simple Summation give #VALUE!?

Threaded View

  1. #1
    Forum Contributor
    Join Date
    08-06-2012
    Location
    Brighton, UK
    MS-Off Ver
    MS Office 2021 and 2019
    Posts
    114

    Why does simple Summation give #VALUE!?

    I am getting the error message "#VALUE!" when I attempt a simple summation - either using SUM() or direct cell addition A1+B1+C1+D1 with some blanks in some of the cells (see sample spreadsheet) - but only in some rows

    I suspect there's something odd about the cells containing the numbers or blanks, but I cannot see it.

    I fear it is something simple, but I've tried for some time to find what's wrong and failed. I would appreciate a fresh pair of eyes to look and hopefully tell me what I'm doing wrong.
    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. Using a summation
    By Oralfloss in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-06-2013, 02:30 PM
  2. Relatively simple summation program
    By excel_newbert in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 06-12-2012, 10:51 PM
  3. Simple summation problem
    By jtn8304 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-08-2011, 06:58 PM
  4. [SOLVED] Give RELEVANT responses to questions. DO NOT give usless list
    By pmartin in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-06-2006, 02:00 PM
  5. How use summation?
    By Akaplen in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-05-2005, 05:05 PM

Tags for this Thread

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