+ Reply to Thread
Results 1 to 4 of 4

by using "sumifs" excel doesn't recognize the value of a cel as criteria

  1. #1
    Registered User
    Join Date
    02-12-2014
    Location
    London
    MS-Off Ver
    Excel 2010
    Posts
    2

    Unhappy by using "sumifs" excel doesn't recognize the value of a cel as criteria

    Dear friends,
    I am using the following problem...I working on a huge spreadsheet...and I am using the funxtion countifs.
    Essentially if I put figures as criteria it works...but if I put the referring cells...something goes wrong...:
    ok if I write : =+SUMIFS($C$4:$C$29333,$B$4:$B$29333,">=41655.7083",$B$4:$B$29333,"<=41655.7299",$G$4:$G$29333,"=1")
    but problemas if I write cells O4 by instance instead of a value such as 41655.7083...: =+SUMIFS($C$4:$C$29333,$B$4:$B$29333,">=O4 ",$B$4:$B$29333,"<= P4 ",$G$4:$G$29333,"=1")

    Why?
    I have to work with a lot of data...so I cannot put always the values one by one...
    Could you help me please?
    Sincerely
    Antonio
    Attached Files Attached Files

  2. #2
    Forum Moderator daddylonglegs's Avatar
    Join Date
    01-14-2006
    Location
    England
    MS-Off Ver
    2016
    Posts
    14,676

    Re: by using "sumifs" excel doesn't recognize the value of a cel as criteria

    You need to "concatenate", e.g.

    "<="&P4
    Audere est facere

  3. #3
    Forum Guru Olly's Avatar
    Join Date
    09-10-2013
    Location
    Darlington, UK
    MS-Off Ver
    Excel 2016, 2019, 365
    Posts
    6,284

    Re: by using "sumifs" excel doesn't recognize the value of a cel as criteria

    Change your Criteria arguments to refer to the cell reference outside quotes:
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    let Source = #table({"Question","Thread", "User"},{{"Answered","Mark Solved", "Add Reputation"}}) in Source

    If I give you Power Query (Get & Transform Data) code, and you don't know what to do with it, then CLICK HERE

    Walking the tightrope between genius and eejit...

  4. #4
    Registered User
    Join Date
    02-12-2014
    Location
    London
    MS-Off Ver
    Excel 2010
    Posts
    2

    Re: by using "sumifs" excel doesn't recognize the value of a cel as criteria

    oh many thanks i will try now if it works

+ 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. SUMIFS with "AND/OR" (Ignoring Blank Criteria)
    By SCLisi in forum Excel Formulas & Functions
    Replies: 14
    Last Post: 09-26-2013, 06:55 PM
  2. HELP: VBA Autofilter criteria, between two dates critera will not recognize "<>"
    By csichel in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-13-2013, 06:21 PM
  3. Replies: 0
    Last Post: 03-09-2013, 11:32 AM
  4. Recognize "formulas "result" as "typed data", through and through.
    By gandolff in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-13-2009, 01:30 PM
  5. [SOLVED] VBA does not recognize Excel worksheet function &quot;indirect&quot;
    By Todkerr in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-12-2005, 04: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