+ Reply to Thread
Results 1 to 3 of 3

SUMIFS - #VALUE and not a result

  1. #1
    Registered User
    Join Date
    11-30-2006
    Posts
    67

    SUMIFS - #VALUE and not a result

    Hi.

    Could anyone look at the enclosed sheet and give a suggestion to why i get #VALUE and not a result??

    =SUMIFS($C$2:$C$177;E2;A2;B2;F2) is what i have tried...

    excelforumfile.xlsx

    Nicolai
    Last edited by Vestlink; 02-05-2015 at 04:14 AM.

  2. #2
    Forum Expert Vikas_Gautam's Avatar
    Join Date
    06-04-2013
    Location
    Ludhiana,Punjab, India
    MS-Off Ver
    Excel 2013
    Posts
    1,850

    Re: SUMIFS - #VALUE and not a result

    Try this in G2 and Drag down:-
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    The Criteria ranges should be equivalent to Sum Range in SIZE to avoid #VALUE Error.
    Regards,
    Vikas Gautam
    Excel-buzz.blogspot.com

    Excel is not a matter of Experience, its a matter of Application.

    Say Thanks, Click * Add Reputation

  3. #3
    Registered User
    Join Date
    11-30-2006
    Posts
    67

    Re: SUMIFS - #VALUE and not a result

    EXCELLENT :-)

    It broaden my excel understanding one notch :-)

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Looking for something simpler than SUMIFS - SUMIFS
    By YAbdelaal in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 05-27-2014, 10:38 AM
  2. [SOLVED] SUMIFS Formula not giving desired result
    By lukemelville in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 10-12-2013, 09:15 AM
  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. [SOLVED] SUMIFS + condition on result
    By Davzx in forum Excel General
    Replies: 4
    Last Post: 06-28-2012, 12:59 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