Results 1 to 14 of 14

SUMIFS producing #VALUE!

Threaded View

  1. #1
    Forum Contributor
    Join Date
    11-23-2013
    Location
    La Crosse, Wi
    MS-Off Ver
    Excel 2010
    Posts
    113

    SUMIFS producing #VALUE!

    I am trying to calculate the number of deaths from tornadoes on various days. The problem is that the death toll is not always known, so I am using ? for that day. For days which are all ? marks, I would prefer to get just a blank cell or simply (missing) if at all possible. If there are mixed values of ? marks and values, I would prefer to just count all of the deaths on that day and come back with a total death toll. I am using the following equation.

    =SUMIFS($D$2:$D$38,$I2,$E$2:$E$38)

    To further complicate things, some of my dates are in the 1800s. It should not be an issue because I am using the same date though.

    I have attached a sample of my spreadsheet.

    Thanks in advance for any help you can provide.

    Jeff B
    Attached Files Attached Files
    Last edited by AliGW; 07-29-2020 at 04:10 AM. Reason: Solved tag added - no need to edit thread title or add solved to post. Thanks.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 0
    Last Post: 08-22-2017, 03:49 PM
  2. [SOLVED] ABS and If producing !VALUE!
    By markDuffy in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-21-2013, 06:39 PM
  3. SUMIFS Puzzle - Trying to avoid adding multiple SUMIFS to get valid result
    By haldavid in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 01-09-2013, 03:42 PM
  4. [SOLVED] Sumifs, problem with the formula: =sumifs(c10:c200,<=today(),0)
    By Faustocruz in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 10-08-2012, 04:26 AM
  5. sumproduct producing #VALUE!
    By Aladin Akyurek in forum Excel Formulas & Functions
    Replies: 30
    Last Post: 09-06-2005, 06:05 PM
  6. sumproduct producing #VALUE!
    By Aladin Akyurek in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 09-06-2005, 11:05 AM
  7. UDF producing #NAME?
    By Jim May in forum Excel General
    Replies: 4
    Last Post: 04-23-2005, 01:06 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1